Mysql Slow Log is Large - Can it be reset?

Shane76

• April 03, 2016 01:52

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

• 

  cPanelMichael

  • April 04, 2016 22:25

  Hello :) Instructions on how to do this are documented at: MySQL :: MySQL 5.5 Reference Manual :: 5.2.7 Server Log Maintenance Note this URL assumes you are using MySQL 5.5. You can change the URL to match your MySQL version number. Thank you.

  0

Please sign in to leave a comment.