InnoDB maintenance question?

[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 
I run out of disk space.
I am currently using MySQL 4.1 but will be moving to 5.x soon.

Thanks,

Lane

Re: InnoDB maintenance question?

[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 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 I

run out of disk

space.

I am currently using MySQL 4.1 but will be moving to 5.x soon.

   Williams, P. Lane wrote:



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]