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 Log is Large - Can it be reset?

Discussion in 'Database Discussions' 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:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page