Josh Marshall-2 wrote: > > It only recovers empty space and re-orders (like a defrag). If your > usage is increasing, the best way is to remove emails. Maybe you need to > run a dbmail-util to remove the deleted emails (there might be a SQL you > can run manually) >
i did a cronjob to take care of this, every 2 & 6 am daily. (dbmail-util -ay) the cronjob also runs a custom SQL that would clear the trash & spam folder older than 30 days. still, the database size is increasing average 2GB per day. btw, do u happen to know the maximum size mysql can handle? with the rate this is going, its gonna be 2TB at the end of next year.. would ANALYZE TABLE gives any performance speed increase etc? > I would consider a MySQL upgrade, I'm not sure how good MySQL 4.0 is > with dbmail. > Oops, typing error! its mysql 5.0.45. i guess that's what happen when u only get 3 hours of sleep for the past week. xD -- View this message in context: http://old.nabble.com/dbmail---mysql-..-tp7810337p26773735.html Sent from the dbmail users mailing list archive at Nabble.com. _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
