Terrible server speeds

Discussion in 'HOWTO-Related Questions' started by gAnDo, Feb 13, 2008.

  1. gAnDo

    gAnDo New Member

    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.
     
  2. falko

    falko Super Moderator ISPConfig Developer

    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.
     
  3. gAnDo

    gAnDo New Member

    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.
     
  4. falko

    falko Super Moderator ISPConfig Developer

Share This Page