Mysql Slow Log is Large - Can it be reset?

[Shane76]

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]

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.