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



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.
Updated on: 2020-06-22T12:49:04+05:30

62 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements