Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

High Server Load on Centos 6.7 /w Litespeed

Discussion in 'Workarounds and Optimization' started by cool_recep, Aug 23, 2015.

  1. cool_recep

    cool_recep Member

    Joined:
    Apr 10, 2013
    Messages:
    24
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Website Owner
    Hi,

    my server load is too high for some time. About 2 weeks.

    High Load.jpg

    High load 2.jpg

    Code:
    root@server [~]# perl mysqltuner.pl
    >>  MySQLTuner 1.5.1 - Major Hayden <major@mhtx.net>
    >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
    >>  Run with '--help' for additional options and output filtering
    [OK] Currently running supported MySQL version 5.6.23
    [OK] Operating on 64-bit architecture
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM
    [--] Data in MyISAM tables: 2G (Tables: 399)
    [--] Data in InnoDB tables: 2G (Tables: 233)
    [--] Data in MEMORY tables: 14M (Tables: 5)
    [!!] Total fragmented tables: 74
    
    -------- Security Recommendations  -------------------------------------------
    [OK] There is no anonymous account in all database users
    [OK] All database users have passwords assigned
    [--] There is 605 basic passwords in the list.
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 2d 17h 23m 46s (82M q [350.842 qps], 3M conn, TX: 4274B, RX: 619B)
    [--] Reads / Writes: 66% / 34%
    [--] Binary logging is disabled
    [--] Total buffers: 16.1G global + 7.2M per thread (500 max threads)
    [OK] Maximum reached memory usage: 16.9G (53.97% of installed RAM)
    [OK] Maximum possible memory usage: 19.7G (62.85% of installed RAM)
    [OK] Slow queries: 0% (2/82M)
    [OK] Highest usage of available connections: 21% (108/500)
    [OK] Aborted connections: 0.00%  (83/3357870)
    [OK] Query cache efficiency: 70.8% (42M cached / 60M selects)
    [!!] Query cache prunes per day: 10298
    [OK] Sorts requiring temporary tables: 0% (4K temp sorts / 5M sorts)
    [OK] Temporary tables created on disk: 20% (439K on disk / 2M total)
    [OK] Thread cache hit rate: 99% (108 created / 3M connections)
    [OK] Table cache hit rate: 69% (1K open / 2K opened)
    [OK] Open file limit used: 13% (1K/10K)
    [OK] Table locks acquired immediately: 99% (39M immediate / 40M locks)
    
    -------- MyISAM Metrics -----------------------------------------------------
    [!!] Key buffer used: 19.2% (3B used / 15B cache)
    [OK] Key buffer size / total MyISAM indexes: 14.9G/344.6M
    [OK] Read Key buffer hit rate: 100.0% (1B cached / 127K reads)
    [!!] Write Key buffer hit rate: 47.4% (10M cached / 5M writes)
    
    -------- InnoDB Metrics -----------------------------------------------------
    [--] InnoDB is enabled.
    [!!] InnoDB  buffer pool / data size: 128.0M/3.0G
    [!!] InnoDB buffer pool <= 1G and innodb_buffer_pool_instances(!=1).
    [OK] InnoDB Used buffer: 89.60% (7339 used/ 8191 total)
    [OK] InnoDB Read buffer efficiency: 99.93% (27964830575 hits/ 27983946430 total)
    [!!] InnoDB Write buffer efficiency: 0.00% (0 hits/ 1 total)
    [OK] InnoDB log waits: 0.00% (0 waits / 714836 writes)
    
    -------- AriaDB Metrics -----------------------------------------------------
    [--] AriaDB is disabled.
    
    -------- Replication Metrics -------------------------------------------------
    [--] No replication slave(s) for this server.
    [--] This is a standalone server..
    
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        Run OPTIMIZE TABLE to defragment tables for better performance
        Increasing the query_cache size over 128M may reduce performance
    Variables to adjust:
        query_cache_size (> 969M) [see warning above]
        innodb_buffer_pool_size (>= 2G) if possible.
        innodb_buffer_pool_instances (=1)
    
    My Software:
    • Litespeed 5.0.5
    • PHP 5.6
    • MySQL 5.6.23
     
    #1 cool_recep, Aug 23, 2015
    Last edited by a moderator: Aug 23, 2015
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,834
    Likes Received:
    85
    Trophy Points:
    78
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    Yes, I suggest reviewing the URL referenced in the previous post in order to troubleshoot the load issues on your system.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice