WARNING: Version 6.1 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.
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
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 fieldsedit
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.