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-queries

Discussion in 'Database Discussions' started by ullalla, Feb 3, 2011.

  1. ullalla

    ullalla Well-Known Member

    Joined:
    Jan 20, 2006
    Messages:
    192
    Likes Received:
    0
    Trophy Points:
    166
    I am having 1 question on mysql-slow-queries.

    If we enable mysql-slow queries on server then is it possible to check the slow queries date wise at /var/log/mysql-slow-queries?


    A quick assistance is appreciated.
     
    #1 ullalla, Feb 3, 2011
  2. coderiser

    coderiser Member

    Joined:
    Jan 31, 2011
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    51
    try using this mysql tuner to fix the issue MySQLTuner
     
    #2 coderiser, Feb 3, 2011
  3. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,622
    Likes Received:
    25
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Hello ullalla,

    What MySQL version are you using? Can you please indicate which one it is and I can advise how to enable the slow query log in /etc/my.cnf for that MySQL version?

    Code:
    mysql_config --version
    Once it has been enabled, you can then view the logs at the location they will create, although I would suggest getting a script like mysqlsla at http://hackmysql.com/mysqlsla to analyze the logs for you.

    Thanks.
     
    #3 cPanelTristan, Feb 3, 2011
  4. ullalla

    ullalla Well-Known Member

    Joined:
    Jan 20, 2006
    Messages:
    192
    Likes Received:
    0
    Trophy Points:
    166
    i have already enabled it, my question is that can we check the logs date wise?
     
    #4 ullalla, Feb 12, 2011
  5. Alexd790

    Alexd790 Registered

    Joined:
    Feb 25, 2011
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    51
    I have face this type of problem, I used MySQL updated version to solve this problem.
     
    #5 Alexd790, Feb 25, 2011
  6. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,622
    Likes Received:
    25
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Is there a section for each log entry indicating something like:

    Code:
    SET timestamp=1255345490;
    If so, then these are epoch dates and you'll be able to use a converter like Date/Epoch Time Converter - JavaScript Utilities/Tools - ESQSoft to grab the date you want converted to regular times, then check through the logs for those dates. Since you haven't provided any entries from your log, I cannot state what you have in the log that might be indicating the dates and times.
     
    #6 cPanelTristan, Mar 1, 2011
(You must log in or sign up to post here.)
Loading...
Similar Threads - Mysql slow queries
  1. Buzz50

    Slow mysql process

    Buzz50, Feb 19, 2017, in forum: Database Discussions
    Replies:
    2
    Views:
    241
    cPanelMichael
    Feb 20, 2017
  2. Nirjonadda

    Is MySQL 5.6 slower than MySQL 5.5?

    Nirjonadda, May 28, 2016, in forum: Database Discussions
    Replies:
    1
    Views:
    778
    cPanelMichael
    Jun 2, 2016
  3. Shane76

    Mysql Slow Log is Large - Can it be reset?

    Shane76, Apr 3, 2016, in forum: Database Discussions
    Replies:
    1
    Views:
    642
    cPanelMichael
    Apr 4, 2016
  4. UHLHosting

    How to debug a slow load in mysql for a website?

    UHLHosting, Mar 9, 2016, in forum: Database Discussions
    Replies:
    2
    Views:
    677
    cPanelMichael
    Mar 9, 2016
  5. mlody69

    Very slow mysql queryies

    mlody69, Feb 9, 2016, in forum: Workarounds and Optimization
    Replies:
    5
    Views:
    867
    cPanelMichael
    Feb 23, 2016

Share This Page