[Maia-users] OT: Innodb maintenance

[Aaron Bennett]

Hi,

This is strictly OT, but our innodb tablespace has grown drastically, 
and reading I've done suggests that some regular table maintenance is 
necessary for innodb databases, but I can't find much information beyond 
suggesting running "analyze table" on each table.

That makes a write lock on the table, which means we won't be able to 
process email while it's running.  Since we've got about 5,000 users, 
and our innodb tablespace is about 30GB, I feel like that's going to 
take FOREVER to run and I'm reluctant to do it unless necessary. 

Robert, David -- and other admins of larger-scale Maia installs -- what 
do you do as far as Innodb maintenance is concerned?

Thanks,

Aaron Bennett