# MySQL 8.0.40 sql/server_component/log_sink_trad.cc: "%.*s %u [%.*s] [MY-%06u] [%.*s] %.*s" (time, thread, label, error code, subsystem, message); log_builtins.cc log_label_from_prio: System, Warning, Note, and ERROR from the sink
# MySQL 5.7.44 sql/log.cc: "%s %u [%s] %.*s"; beats' 5.5.53 and MariaDB 10.4.8 lines put a six-digit date, or a date and time with a space and the thread, before the label
# Lines from Elastic beats v9.5.5 filebeat/module/mysql/error/test and lnav v0.14.1 mysql_error_log samples
2019-03-24T13:44:25.484123Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.15) initializing of server in progress as process 1640 ⇒ {"rule": "mysql", "level": "info", "leveled": true, "name": "Server", "message": "/usr/sbin/mysqld (mysqld 8.0.15) initializing of server in progress as process 1640", "prefixed": true}
2019-03-24T13:44:27.924508Z 5 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. ⇒ {"rule": "mysql", "level": "warn", "name": "Server", "message": "root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option."}
2019-03-24T13:44:31.533096Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. ⇒ {"rule": "mysql", "level": "warn", "name": "Server", "message": "CA certificate ca.pem is self signed."}
2023-03-07T09:34:58.461438Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 14  user: 'sherlock'. ⇒ {"rule": "mysql", "level": "warn", "name": "Server", "message": "/usr/sbin/mysqld: Forcing close of thread 14  user: 'sherlock'."}
2019-03-24T13:44:34.572158Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060 ⇒ {"rule": "mysql", "level": "info", "leveled": true, "name": "Server", "message": "X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060"}
2020-08-06T14:25:02.835618Z 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin ⇒ {"rule": "mysql", "level": "info", "leveled": true, "name": "InnoDB", "message": "DDL log recovery : begin"}
2020-08-06T14:25:02.835618Z 0 [Note] DDL log recovery : begin ⇒ {"rule": "mysql", "level": "info", "leveled": true, "name": "", "message": "DDL log recovery : begin"}
2016-12-09T12:08:33.335060Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). ⇒ {"rule": "mysql", "level": "warn", "name": "", "message": "TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details)."}
2016-12-09T12:08:33.351596Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins ⇒ {"rule": "mysql", "level": "info", "leveled": true, "name": "", "message": "InnoDB: Mutexes and rw_locks use GCC atomic builtins"}
2023-03-12T15:30:16.866015Z 4016575 [Note] Aborted connection 4016575 to db: 'testdb' user: 'sherlock' host: 'localhost' (Got an error reading communication packets) ⇒ {"rule": "mysql", "level": "info", "leveled": true, "name": "", "message": "Aborted connection 4016575 to db: 'testdb' user: 'sherlock' host: 'localhost' (Got an error reading communication packets)"}
230312 19:26:00 [Warning] IP address '10.10.10.10' could not be resolved: Name or service not known ⇒ {"rule": "mysql", "level": "warn", "name": "", "message": "IP address '10.10.10.10' could not be resolved: Name or service not known"}
161209 14:18:50 [Note] Plugin 'FEDERATED' is disabled. ⇒ {"rule": "mysql", "level": "info", "leveled": true, "name": "", "message": "Plugin 'FEDERATED' is disabled."}
2019-10-16 17:25:43 12 [ERROR] Event Scheduler: [root@localhost][test.test_error_log] hi from the error log ⇒ {"rule": "mysql", "level": "error", "name": "", "message": "Event Scheduler: [root@localhost][test.test_error_log] hi from the error log"}
2019-10-16 17:24:15 0 [Note] InnoDB: Using Linux native AIO ⇒ {"rule": "mysql", "level": "info", "leveled": true, "name": "", "message": "InnoDB: Using Linux native AIO"}
2023-03-02 17:00:06 200 [Warning] Access denied for user 'sherlock'@'localhost' (using password: NO) ⇒ {"rule": "mysql", "level": "warn", "name": "", "message": "Access denied for user 'sherlock'@'localhost' (using password: NO)"}
# constructed 2026-10-21T14:03:01.123456Z 0 [ERROR] [MY-010119] [Server] Aborting ⇒ {"rule": "mysql", "level": "error", "name": "Server", "message": "Aborting"}
# constructed 2026-10-21T14:03:01.123456+02:00 0 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation. ⇒ {"rule": "mysql", "level": "error", "name": "InnoDB", "message": "Operating system error number 2 in a file operation."}
# constructed 2026-10-21T14:03:01.123456Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use ⇒ {"rule": "mysql", "level": "error", "name": "", "message": "Can't start server: Bind on TCP/IP port: Address already in use"}
# constructed 161209  9:08:33 [ERROR] /usr/sbin/mysqld: unknown option '--acme' ⇒ {"rule": "mysql", "level": "error", "name": "", "message": "/usr/sbin/mysqld: unknown option '--acme'"}
# lines InnoDB and mysqld_safe print without a label, other labels, and other programs
161209 14:18:50 InnoDB: The InnoDB memory heap is disabled ⇒ {"rule": "plain", "level": "info", "leveled": false, "message": "161209 14:18:50 InnoDB: The InnoDB memory heap is disabled"}
161209 13:08:33 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql ⇒ {"rule": "plain", "level": "info", "leveled": false, "message": "161209 13:08:33 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql"}
191015  9:46:45	    13 Query	SHOW /*!50002 GLOBAL */ STATUS ⇒ {"rule": "plain", "level": "info", "leveled": false, "message": "191015  9:46:45\t    13 Query\tSHOW /*!50002 GLOBAL */ STATUS"}
# constructed 2026-10-21T14:03:01.123456Z 0 [Error] [MY-010119] [Server] mixed case is not a label MySQL prints ⇒ {"rule": "plain", "level": "info", "leveled": false, "message": "2026-10-21T14:03:01.123456Z 0 [Error] [MY-010119] [Server] mixed case is not a label MySQL prints"}
# constructed 2026-10-21T14:03:01.123456Z 0 [Info] [MY-010119] [Server] Info is not a MySQL label ⇒ {"rule": "plain", "level": "info", "leveled": false, "message": "2026-10-21T14:03:01.123456Z 0 [Info] [MY-010119] [Server] Info is not a MySQL label"}
# constructed 2026-10-21T14:03:01.123456Z [Warning] no thread id ⇒ {"rule": "layout", "level": "warn", "message": "no thread id"}
# constructed 2026-10-21T14:03:01Z 0 [Warning] no fraction ⇒ {"rule": "plain", "level": "info", "leveled": false, "message": "2026-10-21T14:03:01Z 0 [Warning] no fraction"}
# constructed 2026-10-21T14:03:01.123456Z 0 [Note]no space ⇒ {"rule": "plain", "level": "info", "leveled": false, "message": "2026-10-21T14:03:01.123456Z 0 [Note]no space"}
# constructed [Note] no stamp ⇒ {"rule": "plain", "level": "info", "leveled": false, "message": "[Note] no stamp"}
# constructed 20261021 14:03:01 [Warning] eight digit date ⇒ {"rule": "layout", "level": "warn", "message": "eight digit date"}
2019-03-24T13:44:25.484123Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.15) initializing of server in progress as process 1640 ⇒ {"rule": "mysql", "level": "info", "name": "Server", "message": "/usr/sbin/mysqld (mysqld 8.0.15) initializing of server in progress as process 1640"}
2018-02-05T13:44:56.657+0100 I CONTROL  [initandlisten] db version v3.2.11 ⇒ {"rule": "mongodb", "level": "info", "name": "CONTROL", "message": "db version v3.2.11"}
