Posted by shanefjordan on September 18, 2008 at 4:37pm
We are running RHEL5.1, Apache2, MySql5, PHP5 and have run into an issue. Our site runs find with normal usage, but if you hold the refresh (F5) key, then the site will crash. We have gotten it to the point that it will not crash the server, but it will take a while before the page responds (for any user). I know that this does not happen on other sites, so we are most likely missing a configuration setting somewhere. Here is what we have:
Apache
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 2
StartServers 8
MinSpareServers 5
MaxSpareServers 20
ServerLimit 40
MaxClients 40
MaxRequestsPerChild 2000Mysql
max_connections = 800
max_user_connections = 800
key_buffer = 36M
myisam_sort_buffer_size = 64M
join_buffer_size = 2M
read_buffer_size = 2M
sort_buffer_size = 3M
table_cache = 1024
thread_cache_size = 286
interactive_timeout = 25
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 32M
max_connect_errors = 999999
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
tmp_table_size = 16MWe have determined that MySQL processes are starting and then going into the sleep state. What would cause this?
Anyone have any ideas?
Thanks,
Shane
Comments
I don't know how to solve it
I don't know how to solve it with php/mysql/drupal, if I were you I would use iptables to limit incoming connections from one host.
This page must help you.