Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Enable slow query log SET GLOBAL slow_query_log = 1; SET GLOBAL long_query_time = 1; -- seconds SET GLOBAL slow_query_log_file = '/var/log/mysql/slow.log'; -- Show current slow query settings SHOW VARIABLES LIKE 'slow%'; SHOW VARIABLES LIKE 'long_query_time';
Result
Open