MysqlLog - File /var/log/mysqld.log

Module for parsing the log file for Mysql, including /var/log/mysql/mysqld.log, /var/log/mysqld.log and /var/opt/rh/rh-mysql*/log/mysql/mysqld.log.

Note

By default, logrotate of mysql.log is set to daily. In some lines of log, there are no timestamp.

Typical content of mysql.log file is:

2018-03-13T06:37:39.651387Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-03-13T06:37:39.719166Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-03-13T06:37:39.784406Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 0
698a7d6-2689-11e8-8944-0800274ac5ef.
2018-03-13T06:37:39.789636Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-03-13T06:37:40.498084Z 0 [Warning] CA certificate ca.pem is self signed.
2018-03-13T06:37:41.080591Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
md5_dgst.c(80): OpenSSL internal error, assertion failed: Digest MD5 forbidden in FIPS mode!
06:37:41 UTC - mysqld got signal 6 ;
2018-03-13T07:43:31.450772Z 0 [Note] Event Scheduler: Loaded 0 events
2018-03-13T07:43:31.450988Z 0 [Note] /opt/rh/rh-mysql57/root/usr/libexec/mysqld: ready for connections.
Version: '5.7.16'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)

Examples

>>> my = MysqlLog((context_wrap(MYSQLLOG)))
>>> my.get('mysqld')[0]['raw_message']
'06:37:41 UTC - mysqld got signal 6 ;'
>>> 'ready for connections' in my
True
class insights.parsers.mysql_log.MysqlLog(context)[source]

Bases: LogFileOutput

Class for parsing /var/log/mysqld.log file.

Note

Please refer to its super-class insights.core.LogFileOutput