With the SHOW STATUS statement, we can get the count of MySQL event-related operations. It can be used as follows -
mysql> SHOW STATUS LIKE '%event%'; +--------------------------+-------+ | Variable_name | Value | +--------------------------+-------+ | Com_alter_event | 16 | | Com_create_event | 6 | | Com_drop_event | 4 | | Com_show_binlog_events | 0 | | Com_show_create_event | 0 | | Com_show_events | 4 | | Com_show_relaylog_events | 0 | +--------------------------+-------+ 7 rows in set (0.17 sec)
The above is the detailed content of How can we get the total number of all MySQL event related operations?. For more information, please follow other related articles on the PHP Chinese website!