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

The timestamp from the log line.

mysql.error.thread_id

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

example: Warning

The log level.

mysql.error.message

type: text

The logged message.

slowlog fields

edit

Contains fields from the MySQL slow logs.

mysql.slowlog.user

The MySQL user that created the query.

mysql.slowlog.host

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

mysql.slowlog.ip

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

mysql.slowlog.query_time.sec

type: float

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

mysql.slowlog.lock_time.sec

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

type: long

The number of rows returned by the query.

mysql.slowlog.rows_examined

type: long

The number of rows scanned by the query.

mysql.slowlog.timestamp

type: long

The unix timestamp taken from the SET timestamp query.

mysql.slowlog.query

The slow query.

mysql.slowlog.id

type: long

The connection ID for the query.