3 ms·
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
by lmz 12y ago
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).
- ck2 12y agoNo 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.