Home  >  Article  >  Database  >  What are the different state variables in MySQL that provide us with a count of event-related operations?

What are the different state variables in MySQL that provide us with a count of event-related operations?

WBOY
WBOYforward
2023-09-08 11:13:09734browse

MySQL 中有哪些不同的状态变量为我们提供了事件相关操作的计数?

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!

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