Josh Marshall-2 wrote: > > >> 1. Is the dbmail_messageblks table cant be optimized? > > It can be optimized, but there's probably no good reason to do it. I did > it once and it didn't increase the database speed it just took a long > time to do it. > >
Would the optimization retrieve some space? ie: reducing the table size? > innodb_log_file_size=192M > innodb_log_buffer_size=8M > innodb_file_per_table > [mysqldump] > quick > quote-names > max_allowed_packet = 128M > [mysql] > [isamchk] > key_buffer = 16M > > 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 would that do the trick? p/s: my mail server hardware is similar to urs, running Fedora 10 with mysql ver 4.0.45. 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. -- View this message in context: http://old.nabble.com/dbmail---mysql-..-tp7810337p26773352.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
