On Sun, 2009-12-06 at 20:13 -0800, Daniel Mejia wrote: > I was thinking to run the OPTIMIZE TABLE command in the dbmail database, bcoz > right now the database size of my organization dbmail database is currently > around 750 GB.
Is there much free space in that table? If not, optimize table wont free any space and probably wont improve access speed etc. Remember that you need as much free space to optimise as the size of the table. I have a mysql server that has 20Gb free in the innodb but only 5Gb free on the disk. Since the messageblk table is 80Gb I can't reclaim that space, but it doesn't make a difference as the innodb engine reuses the space fairly well. Note also that to optimise a table means to read it and write it out with the table locked. A 750Gb database will take a loooong time and you wont be able to write to it for that time. Josh. _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail