如何获取所有 MySQL 事件相关操作的计数?
mysqlmysqli database
借助 SHOW STATUS 语句,我们可以获取 MySQL 事件相关操作的计数。用法如下 −
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)