Hi, I am trying to optimize mysql a bit. I have changed my max connections (To 500), key_buffer_size (To 128MB… I hope), and table cache (To 5000)… What else should I change?
Here is my current settings…
What is “key_buffer_size 8388600” are those in bits? Was it that 8MB? lol…
http://designermichael.com/share/sunSolaris_files/right.htm
I just changed it to 134217728. 128MB x 1024 x 1024 = 134217728. That correct?
Also, here is my mySQL server status. It shows the percentage of selects vs inserts/updates, and etc…
http://designermichael.com/share/sunSolaris_files/server_status.htm
Some other things you should note… This server has 4GB Ram, single dedicated core, burstable to 8. As of today, I am moving all content onto a different server so it will become dedicated php/mysql.
I am trying to get the setting fine tuned for 4GB of Ram. I guess I will have to move to 64BIT mysql if I go beyond that?