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 :
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 ?
- I am using a dedicated server.
my.cnffile 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
The site will stop responding sometime when I click on any hyperlink (post, page just anything that requires action).