How to manage a growing MySQL slow_log table?
1
vote
3
answers
4608
views
I see MySQL supports storing slow_log as a table (internally using mysql/slow_log.CSV file), and this appears convenient, but is it a feature I should use in production? I found online articles on the importance of temporarily disabling slow query logging while rotating the file log, but what's the best practice for managing slow_log.CSV? eg. copy and truncate table or rotate the slow_log.CSV just like db-slow.log?
Asked by Piers C
(111 rep)
Mar 26, 2018, 04:52 PM
Last activity: Apr 21, 2025, 07:15 PM
Last activity: Apr 21, 2025, 07:15 PM