Update files or a table every 5 seconds or for every update to a table whichever is the less frequent
This worked for me.

create event event_name on schedule every 5 second starts now()
do
begin
if (select update_time+5&gt;=now() from information_schema.TABLES 
where table_name='Table_name')
then call procedure_name();
end if;
end//


Here the event checks every 5 seconds if any update happened in the last 5 seconds on the table. If yes it simply calls the procedure update_file or something.