News for hackers. Stuff that matters.
Re:Making MySQL Better at GitHub by ck2 on Tuesday September 02, 2014 @04:54PM (#8260091)
Did you remember to move the undo log outside of ibdata1 ?

http://dev.mysql.com/doc/refman/5.6/en/innodb-undo-tablespac...

Because in mysql, ibdata1 can never shrink, only grow.

And that's how you end up with massive ibdata1 files that cannot be managed.

Oh and undo can only be moved outside of ibdata when mysql is being initialized, not afterwards.

innodb has some serious flaws

http://www.percona.com/blog/wp-content/uploads/2010/04/InnoD...

Re:Making MySQL Better at GitHub by lmz on Tuesday September 02, 2014 @07:57PM (#8260836)
Can you actually shrink the undo logs once you move them out of ibdata1? From your link:

Users cannot drop the separate tablespaces created to hold InnoDB undo logs, or the individual segments inside those tablespaces.

The most important part to control ibdata1 growth is innodb_file_per_table (default now).

Re:Making MySQL Better at GitHub by ck2 on Tuesday September 02, 2014 @08:10PM (#8260874)
No you cannot shrink them but more importantly they do not have to be cached.

The rest of ibdata1 has to be cached for performance.

Impossible to isolate the caching needs unless undo is moved outside and 99% of servers out there have probably not been setup with external undo logs because most admin do not know of this limitation after it has been configured.

Only way around this is to rebuild the entire database, loads of fun.

Re:Making MySQL Better at GitHub by vtal on Tuesday September 02, 2014 @11:05PM (#8261327)
couldn't you use innodb_file_per_table and not worry about the huge ibdata1 file?
Re:Making MySQL Better at GitHub by ck2 on Tuesday September 02, 2014 @11:43PM (#8261402)
No file_per_table does not change anything about the unlimited growth of the undo log in the ibdata1 file.