MySQL fieldsedit
Module for parsing the MySQL log files.
mysqledit
Fields from the MySQL log files.
mysql.thread_idThe connection or thread ID for the query.
type: long
erroredit
Contains fields from the MySQL error logs.
mysql.error.thread_idtype: alias
alias to: mysql.thread_id
mysql.error.leveltype: alias
alias to: log.level
mysql.error.messagetype: alias
alias to: message
slowlogedit
Contains fields from the MySQL slow logs.
mysql.slowlog.lock_time.secThe amount of time the query waited for the lock to be available. The value is in seconds, as a floating point number.
type: float
mysql.slowlog.rows_sentThe number of rows returned by the query.
type: long
mysql.slowlog.rows_examinedThe number of rows scanned by the query.
type: long
mysql.slowlog.rows_affectedThe number of rows modified by the query.
type: long
mysql.slowlog.bytes_sentThe number of bytes sent to client.
type: long
format: bytes
mysql.slowlog.bytes_receivedThe number of bytes received from client.
type: long
format: bytes
mysql.slowlog.query- The slow query.
mysql.slowlog.idtype: alias
alias to: mysql.thread_id
mysql.slowlog.schemaThe schema where the slow query was executed.
type: keyword
mysql.slowlog.current_userCurrent authenticated user, used to determine access privileges. Can differ from the value for user.
type: keyword
mysql.slowlog.last_errnoLast SQL error seen.
type: keyword
mysql.slowlog.killedCode of the reason if the query was killed.
type: keyword
mysql.slowlog.query_cache_hitWhether the query cache was hit.
type: boolean
mysql.slowlog.tmp_tableWhether a temporary table was used to resolve the query.
type: boolean
mysql.slowlog.tmp_table_on_diskWhether the query needed temporary tables on disk.
type: boolean
mysql.slowlog.tmp_tablesNumber of temporary tables created for this query
type: long
mysql.slowlog.tmp_disk_tablesNumber of temporary tables created on disk for this query.
type: long
mysql.slowlog.tmp_table_sizesSize of temporary tables created for this query.
type: long
format: bytes
mysql.slowlog.filesortWhether filesort optimization was used.
type: boolean
mysql.slowlog.filesort_on_diskWhether filesort optimization was used and it needed temporary tables on disk.
type: boolean
mysql.slowlog.priority_queueWhether a priority queue was used for filesort.
type: boolean
mysql.slowlog.full_scanWhether a full table scan was needed for the slow query.
type: boolean
mysql.slowlog.full_joinWhether a full join was needed for the slow query (no indexes were used for joins).
type: boolean
mysql.slowlog.merge_passesNumber of merge passes executed for the query.
type: long
mysql.slowlog.sort_merge_passesNumber of merge passes that the sort algorithm has had to do.
type: long
mysql.slowlog.sort_range_countNumber of sorts that were done using ranges.
type: long
mysql.slowlog.sort_rowsNumber of sorted rows.
type: long
mysql.slowlog.sort_scan_countNumber of sorts that were done by scanning the table.
type: long
mysql.slowlog.log_slow_rate_typeType of slow log rate limit, it can be
sessionif the rate limit is applied per session, orqueryif it applies per query.type: keyword
mysql.slowlog.log_slow_rate_limitSlow log rate limit, a value of 100 means that one in a hundred queries or sessions are being logged.
type: keyword
mysql.slowlog.read_firstThe number of times the first entry in an index was read.
type: long
mysql.slowlog.read_lastThe number of times the last key in an index was read.
type: long
mysql.slowlog.read_keyThe number of requests to read a row based on a key.
type: long
mysql.slowlog.read_nextThe number of requests to read the next row in key order.
type: long
mysql.slowlog.read_prevThe number of requests to read the previous row in key order.
type: long
mysql.slowlog.read_rndThe number of requests to read a row based on a fixed position.
type: long
mysql.slowlog.read_rnd_nextThe number of requests to read the next row in the data file.
type: long
innodbedit
Contains fields relative to InnoDB engine
mysql.slowlog.innodb.trx_idTransaction ID
type: keyword
mysql.slowlog.innodb.io_r_opsNumber of page read operations.
type: long
mysql.slowlog.innodb.io_r_bytesBytes read during page read operations.
type: long
format: bytes
mysql.slowlog.innodb.io_r_wait.secHow long it took to read all needed data from storage.
type: long
mysql.slowlog.innodb.rec_lock_wait.secHow long the query waited for locks.
type: long
mysql.slowlog.innodb.queue_wait.secHow long the query waited to enter the InnoDB queue and to be executed once in the queue.
type: long
mysql.slowlog.innodb.pages_distinctApproximated count of pages accessed to execute the query.
type: long
mysql.slowlog.usertype: alias
alias to: user.name
mysql.slowlog.hosttype: alias
alias to: source.domain
mysql.slowlog.iptype: alias
alias to: source.ip