I've attached the my.cnf we're using in a hope that my config tweaks can help others. For comparison my hardware is 3Gb RAM, Celeron 3GHz on linux 2.6.18 and MySQL 5.0.32 - and currently I have 135 connections and it's still half an hour before everyone starts work. Here we have 4,400 accounts on the server.
[...]
myisam_sort_buffer_size = 64M
This, obviously, won't have any effect if you are using the default InnoDB storage engine, it'll at best just waste your memory.
key_buffer = 1024M key_buffer_size = 16M
I'm not 100% sure, but I think these are MyISAM only. I think the roughly equivalent InnoDB setting is:
innodb_buffer_pool = 1024M
innodb_buffer_pool_size=100M
This should probably be about 1/2 if total memory if the machine is a dedicated InnoDB database server or about 1/4 if it's also running all the other mail services (webmail, dbmail, etc.).
Another thing that is worth doing is bypassing OS caching for table access because MySQL does it's own caching, and is much more efficient than the generic OS algorithm:
innodb_flush_method=O_DIRECT Gordan _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
