HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (
-   HOWTO-Related Questions (
-   -   Terrible server speeds (

gAnDo 13th February 2008 01:06

Terrible server speeds

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.

falko 13th February 2008 19:30


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.

gAnDo 13th February 2008 22:04

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)

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


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.

falko 14th February 2008 19:31

This might be helpful for optimizing Apache:

All times are GMT +2. The time now is 02:40.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.