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 Slow on certain queries

Discussion in 'General Discussion' started by Acieke, Aug 1, 2007.

  1. Acieke

    Acieke Member

    Joined:
    Nov 13, 2004
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    Hello,

    Since a few days I'm experiencing some strange mysql problems:
    On certain queries, that cpanel runs for example to list user's db, mysql is VERY slow or just doesn't respond; on other queries it runs normally.

    By running mtop, I get the following queries to be slow:
    Mostly, the query "SELECT user,db from Db WHERE IN ('ace2\_testdb')", which is run when you click "MySQL Databases" in cPanel, is problematic.

    When I manually run a SELECT User,DB FROM DB, it gives no problem.
    This morning I ran mtop again, and saw a few of the above queries that were hung, and also some 5 "FLUSH PRIVILEGES" that were hung.

    I ran myisamchk and mysqlcheck --repair on all the mysql db tables, doesn't help. I did a upcp, as a newer version was available, no help. Also mysqlup --force didn't help.

    For any advice on this I would be very grateful!

    Thanks
    Fréderic
     
    #1 Acieke, Aug 1, 2007
    Last edited: Aug 1, 2007
  2. jalal

    jalal Active Member

    Joined:
    Jun 15, 2005
    Messages:
    33
    Likes Received:
    0
    Trophy Points:
    6
    Same here

    I've got the same problem here. Queries that used to take about 10secs take between 10-12 minutes.

    I've run all cPanel updates and checked the tables, but can't find anything wrong yet.

    :(
     
  3. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
Loading...

Share This Page