The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Load averages are ok ,but site loading is slow

Discussion in 'Workarounds and Optimization' started by rioabraham, Nov 17, 2011.

  1. rioabraham

    rioabraham Registered

    Joined:
    Nov 16, 2011
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Pathanamthitta, India
    cPanel Access Level:
    Website Owner
    Load averages are ok ,but site loading is slow

    My server load averages( 2.86 2.10 1.75) look normal after i added some optimizations recommended on this forum ,but site loading is slow.I have run optimise tables from admincp-vbulletin and also done it from ssh .I dont know linux to start with ,i've done most ssh cmds which i saw in this forum.

    Specs
    I've checked my monthly bandwidth usage it almost doubled from last 2 months .Nah there is no increase in visitors as alexa rank has gone down from 39K to 50K ,if i say.I have heard that slow loading websites can get low ranks in google,may be that is the cause for alexa rank drop.
    [​IMG]

    Here are some configurations i have done.
    vi /etc/my.cnf
    Code:
    [mysqld]
    local-infile=0
    max_connections=200
    key_buffer_size=256M
    myisam_sort_buffer_size=64M
    open_files_limit=50000
    long_query_time=4
    read_buffer_size=4M
    sort_buffer_size=4M
    join_buffer_size=1M
    read_rnd_buffer_size=8M
    table_cache=10K
    thread_cache_size=8
    max_allowed_packet=1M
    max_connect_errors=10
    query_cache_limit=16M
    query_cache_size=128M
    tmp_table_size=64M
    max_heap_table_size=64M
    skip-innodb
    skip-federated
    log-bin=mysql-bin
    server-id=1
    skip-name-resolve
    skip-locking
    tmpdir=/mysqltmp
    log-slow-queries= /var/lib/mysql/slow.log
    
    
    [mysqld_safe]
    open_files_limit=8192
    
    [mysqldump]
    max_allowed_packet=16M
    
    [mysql]
    no-auto-rehash
    
    [myisamchk]
    key_buffer_size=256M
    sort_buffer_size=256M
    read_buffer_size=2M
    write_buffer_size=2M
    
    [isamchk]
    key_buffer_size=256M
    sort_buffer_size=256M
    read_buffer_size=2M
    write_buffer_size=2M
    
    [mysqlhotcopy]
    interactive-timeout
    
    
    
    After running
    ./Mysqltuner.pl
    Code:
    
     >>  MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
     >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
     >>  Run with '--help' for additional options and output filtering
    
    -------- General Statistics --------------------------------------------------
    [--] Skipped version check for MySQLTuner script
    [OK] Currently running supported MySQL version 5.1.56-log
    [!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: +Archive -BDB -Federated -InnoDB -ISAM -NDBCluster
    [--] Data in MyISAM tables: 2G (Tables: 547)
    [--] Data in MEMORY tables: 7M (Tables: 50)
    [!!] Total fragmented tables: 12
    
    -------- Security Recommendations  -------------------------------------------
    [OK] All database users have passwords assigned
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 1d 1h 8m 49s (3M q [41.887 qps], 244K conn, TX: 168B, RX: 1B)
    [--] Reads / Writes: 76% / 24%
    [--] Total buffers: 448.0M global + 17.2M per thread (200 max threads)
    [!!] Allocating > 2GB RAM on 32-bit systems can cause system instability
    [!!] Maximum possible memory usage: 3.8G (95% of installed RAM)
    [OK] Slow queries: 0% (2K/3M)
    [OK] Highest usage of available connections: 18% (37/200)
    [OK] Key buffer size / total MyISAM indexes: 256.0M/565.0M
    [OK] Key buffer hit rate: 100.0% (665M cached / 152K reads)
    [OK] Query cache efficiency: 56.1% (1M cached / 2M selects)
    [OK] Query cache prunes per day: 0
    [OK] Sorts requiring temporary tables: 0% (49 temp sorts / 225K sorts)
    [OK] Temporary tables created on disk: 8% (4K on disk / 60K total)
    [OK] Thread cache hit rate: 98% (3K created / 244K connections)
    [OK] Table cache hit rate: 67% (896 open / 1K opened)
    [OK] Open file limit used: 6% (1K/20K)
    [OK] Table locks acquired immediately: 99% (3M immediate / 3M locks)
    
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        Run OPTIMIZE TABLE to defragment tables for better performance
    
    
    


    Daily Processes log
    [​IMG]

    Disk Usage
    [​IMG]

    Process manager
    [​IMG]
     

    Attached Files:

    #1 rioabraham, Nov 17, 2011
    Last edited: Nov 18, 2011
  2. storminternet

    storminternet Well-Known Member

    Joined:
    Nov 2, 2011
    Messages:
    462
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Hello,

    From the daily process logs it has been noticed that most of the php processes were defunct and they were using high cpu resources. It is better if you check scripts and optimize it with the web developer. Longer the script execution time slower the site :D
     
  3. minosjl

    minosjl Well-Known Member

    Joined:
    Jun 4, 2011
    Messages:
    168
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hi brother,


    Basically defunct processes is also known as a "zombie". It means that it's finished but still depends on a "parent" which is still alive .You can kill those processes .What's the php handler you are using,Please recompile your easyapche with correct handler and incase of the vbulletin , i think it may occured due to the zend optimiser + ironcube conflict issues on apache .If both of them are currently enabled , please uninstall one of them as recommended by Vbulletin .

    Please verify these things :)
     
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    You might also want to check loading times on the site itself via a browser to see how long each component takes to load. That could be a good indicator of what might be slowing it down:

    Pingdom Tools

    This is a tool that can be used to tell you how long each element on your site takes to load for a set page.
     
Loading...

Share This Page