Site not responding error – taking long to load

2 Views

I have a wordpress website which gets around 20K visits a days and with around 7pages/visit and 62 hits per visit.

My server is :

Read More

8 processors –> Intel(R) Xeon(R) CPU E5405 @ 2.00GHz

8 GB RAM

Now my users are complaining about that the site takes time to load sometimes and craches giving the taking too long to load and it also happened to me a couple of times wher i thought it was my connection.

From previous issues I know that there is a query that sometimes take too long and the site was crashing from it. I then tweaked the server and changed the query_cach_size (because on days with traffic spike the site was stopping alot) in the my.cnf file into 256MB and after that the site stopped the errors on busy days but started giving this kind of error.

Any ideas ? How can I monitor my site and see when it goes down and what is causing it to troubleshoot this ?

EDIT:

  1. I am using a dedicated server.

  2. The my.cnf file looks like: 

    [mysqld]
max_connections = 250
safe-show-database
skip-locking
key_buffer = 128M
max_allowed_packet = 24M
table_cache = 700
sort_buffer_size = 16M
read_buffer_size = 8M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 64M
query_cache_size = 128M
max_heap_table_size = 180M
tmp_table_size = 180M
thread_cache_size = 16
wait_timeout = 45
interactive_timeout = 600
skip-name-resolve
skip-innodb

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 80M
sort_buffer_size = 64M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 80M
sort_buffer_size = 64M
read_buffer = 2M
write_buffer = 2M

  3. The site will stop responding sometime when I click on any hyperlink (post, page just anything that requires action).

Thank you

Post Views: 2

Related posts

Leave a Reply

2 comments

  2. Suggestions for your my.cnf [mysqld] section

    read_buffer_size=256K
read_rnd_buffer_size=256K
thread_cache_size=250

    Let me know how it goes. Thanks