[Maia-users] OT: Innodb maintenance

[Jacob Leaver]

>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
>
>   
ReachONE has about 15k of email accounts, and we average roughly 1
million messages a day.  We spent some time setting up the maia
quarantine in mysql as a master - master replication environment, with
lvs as the loadbalancing frontend.   From time to time, I'd say roughly
once a quarter or even less frequently, we will take one of the two
servers off-line, and optimize all the tables, put that one back online,
and do the same to the other.  This has been working well for us for the
better part of two years.  I do feel that it makes a difference in
speed, and it certainly makes a difference in table size.   It's worth
noting that we use the innodb file-per-table option.

Jacob Leaver
ReachONE Internet