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.

high mysql throughput / website load slow

Discussion in 'Workarounds and Optimization' started by mahdy_sharifi, Dec 29, 2014.

  1. mahdy_sharifi

    mahdy_sharifi Well-Known Member

    Joined:
    Feb 26, 2012
    Messages:
    175
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Hello :

    on a big server with many user and website from 11AM - 00AM our mysql throughput reaised in max (60 - 80M)
    this timestamp our customer website load slowing .

    we have,'t any Disk IO , and server HDD : 6 * 600 G SAS 15K + 64 G RAM

    mysql config :
    innodb_buffer_pool_size=8192M (2 G above mysqltuner recommendation)

    mysqlt.png


    Can You Help ?


    Regards
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. mahdy_sharifi

    mahdy_sharifi Well-Known Member

    Joined:
    Feb 26, 2012
    Messages:
    175
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    thanks , output :

     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    You could try modifying your /etc/my.cnf file based on the recommendations from the tuner and then running the tuner again after 24 hours. However, you may want to consult with a qualified system administrator if you do not receive user-feedback to your results.

    Thank you.
     
Loading...

Share This Page