InnoDB maintenance question?

2005-11-06 Thread Williams, P. Lane
I have an ibdata file that is growing and growing and growing Are there maintenance routines that I can run to keep this file in check? My database is performing close to half a million transactions a day and this file is now well over 75GB. Can I expect this file to continue to grow, until

Re: InnoDB maintenance question?

2005-11-06 Thread Gleb Paharenko
Hello. Have a look here: http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html Consider about switching to per-table tablespace: http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html have an ibdata file that is growing and growing and growing Are there