What are the different status variables in MySQL which provide us the counts
of 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.

Sharon Christine

e

Updated on: 22-Jun-2020

37 Views

Kickstart Your Career

Get certified by completing the course

Get Started