I have 4 MySQL 4.0.16 servers, all with Dual 3ghz Xeons and 4GB of RAM. They use InnoDB for all tables, and the ibdata file is 70GB. The DBs seem to be a little slow, and the darn thing is always using a huge chunk of swap. I've tried increasing and decreasing what it's allowed to use, but this seems to be the best working settings.
Here are my InnoDB settings in my.cnf: innodb_log_files_in_group=2 innodb_log_file_size=512M innodb_buffer_pool_size = 1512M innodb_additional_mem_pool_size = 20M Can any optimizations be done to this, or do I just need to get more RAM for these servers? I believe I can go up to 6GB of RAM, but it requires an OS upgrade to handle anything over 4GB. I know that the biggest DB in that chunk is about 20GB itself, with around 5-10GB in it's biggest table. Memory status: Mem: 3943852K av, 3938184K used, 5668K free, 0K shrd, 209456K buff Swap: 2096440K av, 1895456K used, 200984K free 1921172K cached Any help would be appreciated, this seemed easier to tweak when it was a MyISAM server. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
