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