[Maia-users] OT: Innodb maintenance

[joel]

Aaron Bennett wrote:
> 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?

I guess our maia install is a bit larger than average - we have 13,000 users
and do about 10 million messages/month. We really don't do any mysql/innodb
maintenance to speak of. It did go through a period where it fell through the
cracks, and for 18 months it was completely ignored, since it somehow kept
working. During this time there had been a power outage at the data center,
and the innodb files were damaged. I eventually got back into the picture
there and discovered the mysql problems, and we ended up having to do a
database dump, drop the database, then recover it from the dump. So, I've kept
an eye on it since then, but in the 2 1/2 years we've been running maia that's
the only mysql maintenance we've done.

J