News for hackers. Stuff that matters.
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.