Improving MYSQL performance

Mysql comes with a default configuration that does works on most machines. If you have a machine with more RAM you can improve mysql performance considerably. You may want to do this if you have a bulletin board that uses mysql.

Detailed how to: gives the basic information.

Quick and dirty method:

Edit /etc/my.cnf and add the following lines. ?? is the size of the mysql buffer. I'm currently using keybuffer=60M . This allocates 60 Megabytes RAM to the Mysql buffer. Dont make it too big or you will run out of RAM/swapspace. You need to restart mysql for this to take effect.


set-variable = key_buffer=??M

0 Replies


Please enter an answer

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct