Hi. I used the how to 'CentOS 5.1 Server Setup: LAMP, Email, DNS, FTP, ISPConfig (a.k.a. The Perfect Server)' to install a new server. I have previously used the centos v5 tutorial and the server worked amazingly (thanks to both article writers by they way)) Unfortunately now I am having extremely slow server issues. Looking at the stats through munin the server load averages about 0.5-1 with 20% CPU and a quarter of the memory used. My database has on average about 200 queries per second (lots I know but my previous slower server had no problem at all with the load) and as I said the server load is still very low. I used the mysql large config file. Also using eaccelerator to cache the php files which really helped load. But still the server is very unresponsive. Can anybody point me at some logs etc to look at which might give me an indication as to what is slowing things down? For example, either the site will time out, images (which definetely do exist!) will fail to load and be replaced by the text or the server will totally die from what I can tell (no ssh access) and I will need to request a reboot. ANY help is appreciated as I am at my wits end especially since using the same config on a less powerful server was nice and fast. I should also add that other sites located in the same server farm are responsive so it doesnt seem to be a problem with our hosts bandwidth etc. Many thanks.
Run Code: top to find out which processes eat up your resources. I'd also take a look at the logs inside the /var/log directory, especially the Apache error log.
Thanks, I had previously looked in there but had not noticed much. My host had a look at my my.cnf file today and seemingly it was not as optimized as I thought... My original (the parts he changed) Code: key_buffer = 512M max_allowed_packet = 1M table_cache = 2000 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M thread_cache_size = 8 changed Code: key_buffer = 256M max_allowed_packet = 64M table_cache = 128M sort_buffer_size = 32M read_buffer_size = 32M read_rnd_buffer_size = 16M thread_cache_size = 64M I think the major change was that the table_cache variable was lowered dramatically (we have 2GB RAM) which seemed to have been using up most of the RAM. Do you have any more recommendations for optimizing mysql for 2GB of RAM with Apache running? Thanks again.
This might be helpful for optimizing Apache: http://www.howtoforge.com/configuring_apache_for_maximum_performance
