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.

Mysql is very Slow

Discussion in 'Database Discussions' started by musioc, Nov 16, 2014.

  1. musioc

    musioc Well-Known Member

    Joined:
    Aug 4, 2011
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    16
    Hello
    We use a cPanel server with bellow details:
    8 core cpu, 48G Ram, HDD SATA2 Enterprise, Load avg : 5
    cPanel 11.46, mysql 5.6.16-cll-lve, cloudlinux (cagefs, db_governor), x86_64

    Recently Websites speed become very slow, They take at least 10 seconds to respond. (other servers respond less than 1 second)
    Static files and pages (php, html, ...) without mysql connection are very fast.

    I checked many things, but problem persists yet.
    I can not find any slow query in slow.log for websites that have problem.
    But these are some slow queries that were run as root:
     
    #1 musioc, Nov 16, 2014
    Last edited: Nov 17, 2014
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. musioc

    musioc Well-Known Member

    Joined:
    Aug 4, 2011
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    16
    Thank you for your reply
    I don't know what is the problem, It is very strange problem.

    Some sites (even with mysql connection) loads very fast and some loads very slow.

    This command take about 10 ~ 20 seconds to run (mysql command):
    I think information_schema is the reason.
     
Loading...

Share This Page