wait.io.table

The wait.io.table domain includes summarized table I/O wait metrics from Performance Schema table table_io_waits_summary_by_table.

Usage

mysql> SELECT * FROM performance_schema.table_io_waits_summary_by_table LIMIT 1\G
*************************** 1. row ***************************
     OBJECT_TYPE: TABLE
   OBJECT_SCHEMA: mysql
     OBJECT_NAME: dd_properties
      COUNT_STAR: 0
  SUM_TIMER_WAIT: 0
  MIN_TIMER_WAIT: 0
  AVG_TIMER_WAIT: 0
  MAX_TIMER_WAIT: 0
      COUNT_READ: 0
  SUM_TIMER_READ: 0
  MIN_TIMER_READ: 0
  AVG_TIMER_READ: 0
  MAX_TIMER_READ: 0
     COUNT_WRITE: 0
 SUM_TIMER_WRITE: 0
 MIN_TIMER_WRITE: 0
 AVG_TIMER_WRITE: 0
 MAX_TIMER_WRITE: 0
     COUNT_FETCH: 0
 SUM_TIMER_FETCH: 0
 MIN_TIMER_FETCH: 0
 AVG_TIMER_FETCH: 0
 MAX_TIMER_FETCH: 0
    COUNT_INSERT: 0
SUM_TIMER_INSERT: 0
MIN_TIMER_INSERT: 0
AVG_TIMER_INSERT: 0
MAX_TIMER_INSERT: 0
    COUNT_UPDATE: 0
SUM_TIMER_UPDATE: 0
MIN_TIMER_UPDATE: 0
AVG_TIMER_UPDATE: 0
MAX_TIMER_UPDATE: 0
    COUNT_DELETE: 0
SUM_TIMER_DELETE: 0
MIN_TIMER_DELETE: 0
AVG_TIMER_DELETE: 0
MAX_TIMER_DELETE: 0

Each column that does not begin with OBJECT_ is a metric that can be collected. For example, to collect only write-related metrics:

level:
  collect:
    wait.io.table:
      metrics:
        - COUNT_WRITE
        - SUM_TIMER_WRITE
        - MIN_TIMER_WRITE
        - AVG_TIMER_WRITE
        - MAX_TIMER_WRITE

All Blip metric names are lowercase when reported.

Metrics are grouped by database and table.

Derived Metrics

None.

Options

`all`

Value	Default	Description
yes		Collect all columns in the table
no	✓	Collect only columns listed in the plan

`exclude`


Value Type	CSV string of db.table
Default	`mysql.,information_schema.,performance_schema.,sys.`

A comma-separated list of database or table names to exclude (ignored if include is set).

`include`


Value Type	CSV string of db.table
Default

A comma-separated list of database or table names to include (overrides option exclude).

`truncate-table`

Value	Default	Description
yes	✓	Truncate table after each successful collection
no		Do not truncate table

If the table is truncated (default), the metrics are delta counters. Else, the values are cumulative counters.

`truncate-timeout`


Value Type	Duration string
Default	250ms

Sets @@session.lock_wait_timeout to avoid waiting too long when truncating the table. Normally, truncating a table is nearly instantaneous, but metadata locks can block the operation.

Group Keys

Key	Value
`db`, `tbl`	Database and table name

Error Policies

Name	MySQL Error
`truncate-timeout`	Error truncating table

MySQL Config

See

and related pages in the MySQL manual.

Changelog

Blip Version	Change
v1.1.0	Added `count_star` metric
v1.0.0	Domain added