Thanks for all the pointers! Though I'm afraid your sliderule* dropped a decimal: 1*10^11 / 7.5*10^5 = 133333.3333, or 13K/message. I'm running 2.2.9 (Ubuntu package). I'll kick the tires and see what happens.
Again, thanks! -Ken * Use of term "sliderule" not intended as a pejorative, but, rather, from the perspective of someone who's lost all too many decimal points while using same. > 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 > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is believed to be clean. > > -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
