Sample Header Ad - 728x90

MySQL - Information_schema Events - How persistent or retention is managed

0 votes
1 answer
204 views
I'm a MS SQL guy and understand agent job history. I'm now working with MySQL. I've searched hi and low but I can't find any solid info on how event data within information_schema.events is persisted, retained for. I plan to setup some MySQL Events but need to understand how reliable the logs are. I don't think we have anything in our my.cnf with regards to retention periods of information_schema. If it's forever - should I try and clean this up with some house-keeping job? I am making events to fire once a week. Ideally these would be retained for 180 days. Events that fire more regularly every 5 minutes, perhaps should only be retained for a month. how do I extend this/ manage this - do people log to a separate table that you can manage yourself?
Asked by Adam (113 rep)
Mar 31, 2021, 11:30 AM
Last activity: Jun 12, 2025, 11:03 PM