Daniel Mejia wrote: > 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? >
It would, but it wouldn't matter if you're getting messages in at
1000/day. You'd delete 800 messages and get 1000 more... and that data
space would then get used by the new messages. If you want things to be
faster, instead try using 'ANALYZE TABLE' to update the indices. It's a
lot faster (and it doesn't rebuild the indices, just rebalance the index
tree and update the index cardinality).
>> 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
>
Well, shutdown dbmail-lmtp and dbmail-imap (and dbmail-pop too),
then restart mysqld.
> 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.
>
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
