Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run ยป
HTML / CSS / JS
-- Redo log variables SHOW VARIABLES LIKE "innodb_log%"; -- innodb_log_file_size: larger = more write buffer, slower recovery -- innodb_log_files_in_group: default 2 -- Undo log SHOW VARIABLES LIKE "innodb_undo%"; -- Long-running transactions bloat the undo log -- Check for long transactions: SELECT * FROM information_schema.INNODB_TRX WHERE TIME_TO_SEC(TIMEDIFF(NOW(), trx_started)) > 60;
Result
Open