> Would the optimization retrieve some space? ie: reducing the table > size?
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) > ok, let say my database size is 760GB (and increasing), can i just: > 1. shut down the mysql server, > 2. change the mysql.cnf file, and > 3. restart the mysql server back up My config file is for MySQL 5.0, so some parameters might be slightly different. Otherwise, yes that should work fine. Take a backup though. > p/s: my mail server hardware is similar to urs, running Fedora 10 with mysql > ver 4.0.45. I would consider a MySQL upgrade, I'm not sure how good MySQL 4.0 is with dbmail. > The number of incoming mails is larger than 20,000 daily, but most of them > are blocked by the Barracuda spam firewall, reducing it to minimum 1000. Indeed, we see 95% of emails blocked at our firewall, one day I turned that off and averaged 10 incoming emails/second. Regards, Josh. _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
