The following are the status variables in MYSQL that provide us with the count of operations related to the event-
-
com_create_event It gives us the number of CREATE EVENT statements executed since the last server restart.
-
Com_alter_event - It gives us the number of ALTER EVENT statements executed since the last server restart.
-
Com_drop_event - It gives us the number of DROP EVENT statements executed since the last server restart.
-
Com_show_create_event - It gives us the number of SHOW CREATE EVENT statements executed since the last server restart.
-
Com_show_events - It gives us the number of SHOW EVENTS statements executed since the last server restart.
The above is the detailed content of What are the different state variables in MySQL that provide us with a count of event-related operations?. For more information, please follow other related articles on the PHP Chinese website!