WARNING: Version 5.5 of Filebeat has passed its EOL date.
This documentation is no longer being maintained and may be removed. If you are running this version, we strongly advise you to upgrade. For the latest information, see the current release documentation.
Module for parsing the MySQL log files.
mysql Fields
Fields from the MySQL log files.
error Fields
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
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.