Home > Database > Mysql Tutorial > 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
Release: 2023-09-08 11:13:09
forward
768 people have browsed it

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!

source:tutorialspoint.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template