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.

long query

Discussion in 'Database Discussions' started by mahdy_sharifi, Jan 20, 2015.

  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

    I see following query cause too long query time even over 200 sec

    Code:
     localhost | information_schema | Query   | 127  | Opening tables  | SELECT data_free FROM tables WHERE ENGINE = 'InnoDB'
    
    Is this munin related database ?

    Regards
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    This is likely stems from the following option that's configured in "Tweak Settings" under the "SQL" tab:

    Use INFORMATION_SCHEMA to acquire MySQL® disk usage

    Per it's description:

    Using INFORMATION_SCHEMA ensures that disk usage by MySQL tables is included in totals. However, enabling this option may cause a significant drop in performance as MySQL may become unresponsive until data collection is complete. Disabling this option causes the system to query the filesystem directly, potentially excluding disk space used by some database tables. Note: If you use a remote MySQL server, you must turn this setting On in order to calculate MySQL disk usage.

    You may want to disable this option to see if it helps improve performance.

    Thank you.
     
  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
    Not resolved yet .

     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    To clarify, are you still experiencing issues after disabling the "Use INFORMATION_SCHEMA to acquire MySQL® disk usage" option on your server?

    Thank you.
     
  5. mahdy_sharifi

    mahdy_sharifi Well-Known Member

    Joined:
    Feb 26, 2012
    Messages:
    175
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    yes ... problem exist after disabling .
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    This is likely an unsupported issue, but feel free to open a support ticket using the link in my signature so we can verify it's not caused by any cPanel configuration settings. You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
Loading...

Share This Page