What are the different status variables in MySQL which provide us the counts of event-related operations?

MySQLMySQLi Database

Followings are the status variables in MYSQL which provide us the counts of event-related operations −

  • Com_create_event It provides us the number of CREATE EVENT statements executed since the last server restart.
  • Com_alter_event − It provides us the number of ALTER EVENT statements executed since the last server restart.
  • Com_drop_event − It provides us the number of DROP EVENT statements executed since the last server restart.
  • Com_show_create_event − It provides us the number of SHOW CREATE EVENT statements executed since the last server restart.
  • Com_show_events − It provides us the number of SHOW EVENTS statements executed since the last server restart.
raja
Published on 22-Feb-2018 08:21:41
Advertisements