Ken D'Ambrosio wrote: >> How much data are you searching through? (how big is your dbmail db?) >> > > Roughly 100 GB; it's got 750K messages or so. > You need to clean and optimize your tables. With a quick calc, that would put you at about 140MB/message. Are you on 2.2.x or 2.3.x?
You should first remove any messages that have been deleted and just waiting to be deleted from the tables run this twice: dbmail-util -ay You should then take some downtime to do for each table OPTIMIZE TABLE dbmail_tablename; If you are running primarily MySQL on your server, then you will want to target about 1.5 GB to 1.75GB of ram usage for it. The following should get you a bit better. You may need to tweak the numbers a bit. If you have too much, then it will fail to start. I think these will work with 2GB of ram. Probably put you at about 1.75GB of ram usage. my.cnf innodb_file_per_table skip-locking innodb_flush_method=O_DIRECT sort_buffer_size=64M read_buffer_size=64M read_rnd_buffer_size=64M innodb_buffer_pool_size=1G innodb_additional_mem_pool_size=512MB innodb_flush_log_at_trx_commit=2 query_cache_size=128M -- Scanned for viruses and dangerous content by MailScanner _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
