Site Is So Slow!

[eluser]Hockeychap[/eluser]
Just a quick post before I whizz off for the night:

1. You're max_connection is exceptionally small. Mine (on a shared server of similar capacity) is set to 500. In my cpanel installation the entry is in /etc/my.cnf on the server. There is a line that reads:

Code:

set-variable = max_connections=500

If you add this line into your my.cnf and then restart your mysql server that should increase the number of connections your server will handle.

2. More importantly, the process breakdown shows that your mysql server is using temporary tables very heavily. These are primarily used when the group by and sort (order by) buffer is too small for the results of your queries. The parameter to have a look at is

key_buffer_size

as temporary tables are often handled on disk.

TO have a look at the temporary table activity have a look at 3 variables: created_tmp_disk_tables , Created_tmp_files, Created_tmp_tables .

If the value for created_tmp_files is high , you are doing a lot of disk io.

A really good script is available here Tuning script. If you download it and run it on your server it will help identify duff config. * Late edit - argh - doesn;t run so well on Centos as the calculator bc isn't available *

Will have a think on the train tomorrow about how we can reduce your overall temp table use.