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.

Showing slow logs

Discussion in 'Workarounds and Optimization' started by k2tec, Jun 25, 2014.

  1. k2tec

    k2tec Well-Known Member

    Joined:
    Aug 26, 2011
    Messages:
    81
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    Netherlands
    cPanel Access Level:
    Root Administrator
    I am running MySQL 5.6 and I read that the log-slow-queries = changed to slow-query-log
    I tried both but the mysql server did not restart.
    this are the changes I tried.
    This is the old one.
    Code:
    log-slow-queries=/var/lib/mysql/slow_queries.log
    long_query_time = 3
    this the new one
    Code:
    slow-query-log=/var/lib/mysql/slow_queries.log
    long_query_time = 3
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    649
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. k2tec

    k2tec Well-Known Member

    Joined:
    Aug 26, 2011
    Messages:
    81
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    Netherlands
    cPanel Access Level:
    Root Administrator
    Thanks Michael,
    I will give it a try tomorrow.
     
  4. k2tec

    k2tec Well-Known Member

    Joined:
    Aug 26, 2011
    Messages:
    81
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    Netherlands
    cPanel Access Level:
    Root Administrator
    Michael
    This okay
    I put this also in my.cnf
    And if you want to see the queries without indexes, but this will fill your log file very fast
     
Loading...

Share This Page