VICIDIAL MYSQL EXPIRE LOGS

first login to your mysql database server and connect to mysql, We have seen major improvements on the database server by changing the expiry logs to one day.

mysql

This will show your current expire logs by day.

SHOW VARIABLES LIKE 'expire_logs_days';

Change the variable to one day with the following command.

SET GLOBAL expire_logs_days=1;

exit