How do I see all MySQL events that are running on my database?

Question

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?

what about `show processlist;`? Is that what you're looking for? — Tomas, Jan 29 '12 at 23:00

score 32 · Accepted Answer · answered Jan 29 '12 at 23:01

its simple SHOW EVENTS lists all of the events in the current schema

To see events for a specific schema, use the FROM clause. For example, to see events for the test schema, use the following statement:

SHOW EVENTS FROM test;

score 20 · Answer 2 · answered Jan 29 '12 at 22:57

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';

To show all events: `USE information_schema; DESCRIBE EVENTS; SELECT * FROM EVENTS; ` — ChiMo, Oct 12 '15 at 01:21

score 14 · Answer 3 · answered Oct 11 '19 at 15:06

14

Show events with more details

SELECT * FROM information_schema.EVENTS

answered Oct 11 '19 at 15:06

Madacol

3,611
34
33

Best answer imho – The Onin Aug 29 '21 at 21:41

Korhan Ozturk · Answer 4 · 2012-01-29T23:15:43.840

4

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

edited Jan 29 '12 at 23:15

answered Jan 29 '12 at 22:58

Korhan Ozturk

11,148
6
36
49

score 3 · Answer 5 · answered Feb 09 '17 at 07:09

3

show events;

will show all the events .

answered Feb 09 '17 at 07:09

karthik

7,041
1
13
12

rizahmed · Answer 6 · 2023-05-16T10:21:06.693

If you want to view all Event Schedulers from all databases in MySQL.

SELECT * FROM information_schema.EVENTS;

If you want to view all Event Schedulers from a specific database in MySQL.

SHOW EVENTS FROM 'your_database_name';

Event Scheduler Specific Query:

SELECT EVENT_DEFINITION
FROM information_schema.EVENTS
WHERE EVENT_NAME = 'your_event_name';

Database Specific Event Scheduler Query:

SELECT EVENT_DEFINITION
FROM information_schema.EVENTS
WHERE EVENT_NAME = 'your_event_name'
AND EVENT_SCHEMA = 'your_database_name';

How do I see all MySQL events that are running on my database?

6 Answers6

Show events with more details