Misao wrote:
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.
I had some of performance issue questions too, but it seems that this list miss them...
What I can suggest is to carefully read mysql manual, especially the tuning part, which mixes up some suggestion about how to set up global variables and how to check information from status variables and feel where problem is.
About your issue, I had it too several months ago, but after I tuned my server that way now I'm ok.
Bye
A.
-- "Imagination is more important than knowledge"
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
