mysql> SELECT * FROM performance_schema.error_log\G *************************** 1. row *************************** LOGGED: 2020-08-06 09:25:00.338624  THREAD_ID: 0 PRIO: System ERROR_CODE: MY-010116  SUBSYSTEM: Server DATA: mysqld (mysqld 8.0.23) starting as process 96344 *************************** 2. row *************************** LOGGED: 2020-08-06 09:25:00.363521  THREAD_ID: 1 PRIO: System ERROR_CODE: MY-013576  SUBSYSTEM: InnoDB DATA: InnoDB initialization has started. ... *************************** 65. row *************************** LOGGED: 2020-08-06 09:25:02.936146  THREAD_ID: 0 PRIO: Warning ERROR_CODE: MY-010068  SUBSYSTEM: Server DATA: CA certificate /var/mysql/sslinfo/cacert.pem is self signed. ... *************************** 89. row *************************** LOGGED: 2020-08-06 09:25:03.112801  THREAD_ID: 0 PRIO: System ERROR_CODE: MY-013292  SUBSYSTEM: Server DATA: Admin interface ready for connections, address: ’127.0.0.1’ port: 33062 

The error_log  table has the following columns. As indicated in the descriptions, all but the DATA  column correspond to fields of the underlying error event structure, which is described in Section 5.4.2.3, “Error Event Fields” . 

• LOGGED 

The event timestamp, with microsecond precision. LOGGED  corresponds to the time  field of error events, although with certain potential differences: 

• time  values in the error log are displayed according to the log_timestamps  system variable setting; see Early-Startup Logging Output Format. 

•The LOGGED  column stores values using the TIMESTAMP  data type, for which values are stored in UTC but displayed when retrieved in the current session time zone; see Section 11.2.2, “The DATE, DATETIME, and TIMESTAMP Types” . 

To display LOGGED  values in the same time zone as displayed in the error log file, first set the session time zone as follows: 

SET @@session.time_zone = @@global.log_timestamps; 

If the log_timestamps  value is UTC  and your system does not have named time zone support installed (see Section 5.1.15, “MySQL Server Time Zone Support” ), set the time zone like this: 

SET @@session.time_zone = ’+00:00’; 

• THREAD_ID 

The MySQL thread ID. THREAD_ID  corresponds to the thread  field of error events. 

