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
Last activity: Jun 12, 2025, 11:03 PM