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.

mysqltuner recommendations

Discussion in 'Workarounds and Optimization' started by sahostking, Jan 19, 2016.

  1. sahostking

    sahostking Well-Known Member

    Joined:
    May 15, 2012
    Messages:
    300
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Cape Town, South Africa
    cPanel Access Level:
    Root Administrator
    Hi

    We host cpanel servers with 8GB of memory and use litespeed.

    When we switch to apache it seems that server keeps randomly having high load.

    IS this due to possibly mysql as whren I run iotop mysql is using 99% constantly under io column

    Now I run mysql tuner and it gives me this:

    query_cache_size (> 256M) [see warning above]
    join_buffer_size (> 1.0M, or always use indexes with joins)
    table_open_cache (> 4096)
    innodb_buffer_pool_size (>= 5G) if possible.
    innodb_buffer_pool_instances (=1)


    innodb_buffer_pool_size (>= 5G) if possible.

    IS that not very high for 500 sites on a server or should I just do as it sais? and make it 5GB?

    Will it help alot?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,762
    Likes Received:
    662
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page