The mysql slow query log is great. But if you don't use if often, or as is likely, never look at it until there is an issue, it can grow unwieldy. Fortunately Percona's mysql clone has options to let you have n copies of the slow query log, each of a maximum size, so that it rotates the logs and keeps the size(s) under control.
You probably already have something like this in your my.cnf file
slow_query_log=1
slow_query_log_file=/somewhere/slow_query.log
So now add this to get additional copies and rotate amongst them.
max_slowlog_size=500M
max_slowlog_files=10
Thank you Percona for yet another great feature.
Thursday, January 5, 2017
Subscribe to:
Posts (Atom)