Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » ibdata1 writes
ibdata1 writes [message #1101] Sun, 15 April 2007 20:14 Go to next message
Tilla is currently offline Tilla
Messages: 5
Registered: April 2007
Junior Member
innodb with file per tablespace set.

altering a single large table to partition 100 smaller.

Seems to be a significant amount of writes happening to ibdata1 file (now 1.5 GB) even though there are no database tables within...

anyone know what it could be?

Thanks.
Report message to a moderator
Re: ibdata1 writes [message #1102 is a reply to message #1101 ] Mon, 16 April 2007 03:21 Go to previous messageGo to next message
carpii is currently offline carpii
Messages: 48
Registered: November 2006
Member
innodb transaction log?
Report message to a moderator
Re: ibdata1 writes [message #1106 is a reply to message #1102 ] Mon, 16 April 2007 20:57 Go to previous messageGo to next message
Tilla is currently offline Tilla
Messages: 5
Registered: April 2007
Junior Member
I dont think so, I have log files in ib_logfile0 and ib_logfile 1...
Report message to a moderator
Re: ibdata1 writes [message #1107 is a reply to message #1106 ] Mon, 16 April 2007 20:59 Go to previous messageGo to next message
Tilla is currently offline Tilla
Messages: 5
Registered: April 2007
Junior Member
Where do indexes go for partitioned tables?

Are they within each partition related to data in that partition only?

I guess a more straight forward question is: Are the indexes partitioned as well as the data?

[Updated on: Mon, 16 April 2007 21:00]

Report message to a moderator
Re: ibdata1 writes [message #1122 is a reply to message #1101 ] Fri, 20 April 2007 18:14 Go to previous message
Peter is currently offline Peter
Messages: 405
Registered: August 2006
Senior Member
Super Guru
undo segment is still located in ibdata1

Heavy IO usually means you have some long running transactions which need a lot of space in undo segment, otherwise it would just stay in buffer pool.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/
Report message to a moderator
Previous Topic:Performance with INSERT on huge tables
Next Topic:Looking for Suggestions on Improving Performance
Goto Forum:
  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Fri Jul 10 00:08:21 EDT 2009

Total time taken to generate the page: 0.01090 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.