On 11/24/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > You have fixed a short term problem but forgot about long term > consequences. > > Email system is a delete/insert/update/select heavy system, if you have > lots of users. Going with innodb you get concurrent reads + writes. I > can do most of the dbmail-util cleanup functions without having to lock > tables. A user can be downloading/updating delete flags of 50K pop3 > messages via dbmail-pop3d and I don't have to worry about it locking up > the system and slowing inserts other updates (pop/imap users) to a > turtle pace. Can't say the same for myisam.
Good point. Im starting to look into moving to innodb tables, but will save the actual upgrade until a server upgrade in Jan/Feb of next year :) . Any good references to start here?