Module for parsing the MySQL log files.
Fields from the MySQL log files.
The connection or thread ID for the query.
Contains fields from the MySQL error logs.
alias to: mysql.thread_id
alias to: log.level
alias to: message
Contains fields from the MySQL slow logs.
The amount of time the query waited for the lock to be available. The value is in seconds, as a floating point number.
The number of rows returned by the query.
The number of rows scanned by the query.
The number of rows modified by the query.
The number of bytes sent to client.
The number of bytes received from client.
- The slow query.
alias to: mysql.thread_id
The schema where the slow query was executed.
Current authenticated user, used to determine access privileges. Can differ from the value for user.
Last SQL error seen.
Code of the reason if the query was killed.
Whether the query cache was hit.
Whether a temporary table was used to resolve the query.
Whether the query needed temporary tables on disk.
Number of temporary tables created for this query
Number of temporary tables created on disk for this query.
Size of temporary tables created for this query.
Whether filesort optimization was used.
Whether filesort optimization was used and it needed temporary tables on disk.
Whether a priority queue was used for filesort.
Whether a full table scan was needed for the slow query.
Whether a full join was needed for the slow query (no indexes were used for joins).
Number of merge passes executed for the query.
Number of merge passes that the sort algorithm has had to do.
Number of sorts that were done using ranges.
Number of sorted rows.
Number of sorts that were done by scanning the table.
Type of slow log rate limit, it can be
sessionif the rate limit is applied per session, or
queryif it applies per query.
Slow log rate limit, a value of 100 means that one in a hundred queries or sessions are being logged.
The number of times the first entry in an index was read.
The number of times the last key in an index was read.
The number of requests to read a row based on a key.
The number of requests to read the next row in key order.
The number of requests to read the previous row in key order.
The number of requests to read a row based on a fixed position.
The number of requests to read the next row in the data file.
Contains fields relative to InnoDB engine
Number of page read operations.
Bytes read during page read operations.
How long it took to read all needed data from storage.
How long the query waited for locks.
How long the query waited to enter the InnoDB queue and to be executed once in the queue.
Approximated count of pages accessed to execute the query.
alias to: user.name
alias to: source.domain
alias to: source.ip