Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Mysql Slow Log is Large - Can it be reset?

Discussion in 'Database Discussion' started by Shane76, Apr 3, 2016.

  1. Shane76

    Shane76 Registered

    Joined:
    Mar 31, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    South Africa
    cPanel Access Level:
    Root Administrator
    Hi

    I have a slow.log located here:

    var/lib/mysql/server1-slow.log

    It is 14G which is massive.

    I did a SET GLOBAL expire_logs_days =5;

    Tried to do a purge
    PURGE BINARY LOGS BEFORE (date(now())+ interval 0 second - interval 5 day);

    but the var/lib/mysql/server1-slow.log is still there.

    Can I simply delete the server1-slow.log file in WinSCP and then restart mysql to have the file regenerated factoring in the expire_log_days new setting?

    Thanks
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,644
    Likes Received:
    1,787
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice