The mysql.event table contains information about MariaDB events. Similar information can be obtained by viewing the INFORMATION_SCHEMA.EVENTS table, or with the SHOW EVENTS and SHOW CREATE EVENT statements.

Since MariaDB 10.0.22 and MariaDB 10.1.9, the table is upgraded live, and there is no need to restart the server if the table has changed.

It contains the following fields:

FieldTypeNullKeyDefaultDescription
dbchar(64)NOPRI
namechar(64)NOPRI
bodylongblobNONULL
definerchar(141)NO
execute_atdatetimeYESNULL
interval_valueint(11)YESNULL
interval_fieldenum('YEAR', 'QUARTER', 'MONTH', 'DAY', 'HOUR', 'MINUTE', 'WEEK', 'SECOND', 'MICROSECOND', 'YEAR_MONTH', 'DAY_HOUR', 'DAY_MINUTE', 'DAY_SECOND', 'HOUR_MINUTE', 'HOUR_SECOND', 'MINUTE_SECOND', 'DAY_MICROSECOND', 'HOUR_MICROSECOND', 'MINUTE_MICROSECOND', 'SECOND_MICROSECOND')YESNULL
createdtimestampNOCURRENT_TIMESTAMP
modifiedtimestampNO0000-00-00 00:00:00
last_executeddatetimeYESNULL
startsdatetimeYESNULL
endsdatetimeYESNULL
statusenum('ENABLED', 'DISABLED', 'SLAVESIDE_DISABLED')NOENABLEDCurrent status of the event, one of enabled, disabled, or disabled on the slaveside.
on_completionenum('DROP','PRESERVE')NODROP
sql_modeset('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'IGNORE_BAD_TABLE_OPTIONS', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH')NOThe SQL_MODE at the time the event was created.
commentchar(64)NO
originatorint(10) unsignedNONULL
time_zonechar(64)NOSYSTEM
character_set_clientchar(32)YESNULL
collation_connectionchar(32)YESNULL
db_collationchar(32)YESNULL
body_utf8longblobYESNULL

Comments

Comments loading...