WARNING: Version 5.6 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 Fields
editMySQL Fields
editModule for parsing the MySQL log files.
mysql Fields
editFields from the MySQL log files.
error Fields
editContains fields from the MySQL error logs.
mysql.error.timestamp
editThe timestamp from the log line.
mysql.error.thread_id
edittype: 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
editexample: Warning
The log level.
mysql.error.message
edittype: text
The logged message.
slowlog Fields
editContains fields from the MySQL slow logs.
mysql.slowlog.user
editThe MySQL user that created the query.
mysql.slowlog.host
editThe host from where the user that created the query logged in.
mysql.slowlog.ip
editThe IP address from where the user that created the query logged in.
mysql.slowlog.query_time.sec
edittype: float
The total time the query took, in seconds, as a floating point number.
mysql.slowlog.lock_time.sec
edittype: 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
edittype: long
The number of rows returned by the query.
mysql.slowlog.rows_examined
edittype: long
The number of rows scanned by the query.
mysql.slowlog.timestamp
edittype: long
The unix timestamp taken from the SET timestamp
query.
mysql.slowlog.query
editThe slow query.
mysql.slowlog.id
edittype: long
The connection ID for the query.