Module for parsing the MySQL log files.

mysql fieldsedit

Fields from the MySQL log files.

error fieldsedit

Contains fields from the MySQL error logs.

mysql.error.timestampedit

The timestamp from the log line.

mysql.error.thread_idedit

type: long

As of MySQL 5.7.2, this is the thread id. For MySQL versions prior to 5.7.2, this field contains the process id.

mysql.error.leveledit

example: Warning

The log level.

mysql.error.messageedit

type: text

The logged message.

slowlog fieldsedit

Contains fields from the MySQL slow logs.

mysql.slowlog.useredit

The MySQL user that created the query.

mysql.slowlog.hostedit

The host from where the user that created the query logged in.

mysql.slowlog.ipedit

The IP address from where the user that created the query logged in.

mysql.slowlog.query_time.secedit

type: float

The total time the query took, in seconds, as a floating point number.

mysql.slowlog.lock_time.secedit

type: float

The amount of time the query waited for the lock to be available. The value is in seconds, as a floating point number.

mysql.slowlog.rows_sentedit

type: long

The number of rows returned by the query.

mysql.slowlog.rows_examinededit

type: long

The number of rows scanned by the query.

mysql.slowlog.timestampedit

type: long

The unix timestamp taken from the SET timestamp query.

mysql.slowlog.queryedit

The slow query.

mysql.slowlog.idedit

type: long

The connection ID for the query.