How do I see all MySQL events that are running on my database?
57,385
Solution 1
The information_schema.EVENTS
table is where to start.
USE information_schema;
DESCRIBE EVENTS;
+----------------------+---------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+---------------+------+-----+---------------------+-------+
| EVENT_CATALOG | varchar(64) | YES | | NULL | |
| EVENT_SCHEMA | varchar(64) | NO | | | |
| EVENT_NAME | varchar(64) | NO | | | |
| DEFINER | varchar(77) | NO | | | |
| TIME_ZONE | varchar(64) | NO | | | |
| EVENT_BODY | varchar(8) | NO | | | |
| EVENT_DEFINITION | longtext | NO | | NULL | |
| EVENT_TYPE | varchar(9) | NO | | | |
| EXECUTE_AT | datetime | YES | | NULL | |
| INTERVAL_VALUE | varchar(256) | YES | | NULL | |
| INTERVAL_FIELD | varchar(18) | YES | | NULL | |
| SQL_MODE | varchar(8192) | NO | | | |
| STARTS | datetime | YES | | NULL | |
| ENDS | datetime | YES | | NULL | |
| STATUS | varchar(18) | NO | | | |
| ON_COMPLETION | varchar(12) | NO | | | |
| CREATED | datetime | NO | | 0000-00-00 00:00:00 | |
| LAST_ALTERED | datetime | NO | | 0000-00-00 00:00:00 | |
| LAST_EXECUTED | datetime | YES | | NULL | |
| EVENT_COMMENT | varchar(64) | NO | | | |
| ORIGINATOR | bigint(10) | NO | | 0 | |
| CHARACTER_SET_CLIENT | varchar(32) | NO | | | |
| COLLATION_CONNECTION | varchar(32) | NO | | | |
| DATABASE_COLLATION | varchar(32) | NO | | | |
+----------------------+---------------+------+-----+---------------------+-------+
SELECT EVENT_NAME FROM EVENTS WHERE EVENT_SCHEMA = 'your_database_name';
Solution 2
Show events with more details
SELECT * FROM information_schema.EVENTS
Solution 3
SHOW EVENTS\G
Which will bring you the list of all existing events. For Show Events Syntax: http://dev.mysql.com/doc/refman/5.1/en/show-events.html
Solution 4
show events;
will show all the events .
![Don P](https://i.stack.imgur.com/ufPVV.jpg?s=256&g=1)
Comments
-
Don P almost 2 years
I have a MySQL database. I am running two MySQL EVENTs. I need to get rid of one. I don't remember it's name. What do I do?
-
ChiMo over 8 yearsTo show all events:
USE information_schema; DESCRIBE EVENTS; SELECT * FROM EVENTS;
-
The Onin almost 3 yearsBest answer imho