MySQL fieldsedit

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

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.