MySQL fields

edit

Module for parsing the MySQL log files.

mysql fields

edit

Fields from the MySQL log files.

error fields

edit

Contains fields from the MySQL error logs.

mysql.error.timestamp

edit

The timestamp from the log line.

mysql.error.thread_id

edit

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.level

edit

example: Warning

The log level.

mysql.error.message

edit

type: text

The logged message.

slowlog fields

edit

Contains fields from the MySQL slow logs.

mysql.slowlog.user

edit

The MySQL user that created the query.

mysql.slowlog.host

edit

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

mysql.slowlog.ip

edit

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

mysql.slowlog.query_time.sec

edit

type: float

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

mysql.slowlog.lock_time.sec

edit

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_sent

edit

type: long

The number of rows returned by the query.

mysql.slowlog.rows_examined

edit

type: long

The number of rows scanned by the query.

mysql.slowlog.timestamp

edit

type: long

The unix timestamp taken from the SET timestamp query.

mysql.slowlog.query

edit

The slow query.

mysql.slowlog.id

edit

type: long

The connection ID for the query.