Home  >  Article  >  Database  >  How can we get the total number of all MySQL event related operations?

How can we get the total number of all MySQL event related operations?

WBOY
WBOYforward
2023-08-27 08:05:21953browse

How can we get the total number of all MySQL event related operations?

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!

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete