Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Check event thread activity SELECT * FROM performance_schema.threads WHERE name LIKE "%event_scheduler%"; -- Batch delete to avoid long transactions and I/O spikes DELIMITER // CREATE EVENT batch_purge ON SCHEDULE EVERY 5 MINUTE DO BEGIN DELETE FROM logs WHERE created_at < NOW() - INTERVAL 90 DAY LIMIT 5000; END// DELIMITER ; -- Schedule heavy work during off-peak hours (2-4 AM) ALTER EVENT weekly_report ON SCHEDULE EVERY 1 WEEK STARTS "2024-01-07 02:00:00";
Result
Open