# MySQL optimization help

**URL:** <https://forum.kirupa.com/t/mysql-optimization-help/273985>\
**Category:** Uncategorized\
**Created:** [October 23, 2008, 11:38am UTC](https://forum.kirupa.com/t/mysql-optimization-help/273985 "2008-10-23T11:38:27Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![DesignerMichael](https://avatars.discourse-cdn.com/v4/letter/d/898d66/32.png) [@DesignerMichael](https://forum.kirupa.com/u/DesignerMichael)\
**Post date:** [October 23, 2008, 11:38am UTC](https://forum.kirupa.com/t/mysql-optimization-help/273985/1 "2008-10-23T11:38:27Z")

</div>

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](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](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?