| Query Count |
{{ data.queryCount.perSec }} (per sec) |
|
{{ data.queryCount.sum }}
{{ data.queryCount.sumPercent }} of total
|
|
| Query Time |
{{ data.queryTime.sumLoad }} load ({{ data.queryTime.percentOfTotal }}) |
|
{{ data.queryTime.sum }}
{{ data.queryTime.percentOfTotal }} of total
|
{{ data.queryTime.avg }} avg
|
|
| Lock Time |
{{ data.lockTime.avgLoad }} (avg load) |
|
{{ data.lockTime.sum }}
{{ data.lockTime.percentOfTotal }} of total
{{ data.lockTime.percentOfQueryTime }} of query time
|
{{ data.lockTime.avg }} avg
|
|
| Innodb Row Lock Wait |
{{ data.innodbRowLockWait.avg }} (avg load) |
|
{{ data.innodbRowLockWait.sum }}
{{ data.innodbRowLockWait.percentOfTotal }} of total
{{ data.innodbRowLockWait.percentOfQueryTime }} of query time
|
{{ metrics.InnoDB_rec_lock_wait.Avg | humanize }} avg
|
|
| Innodb IO Read Wait |
{{ data.innodbIOReadWait.avg }} (avg load) |
|
{{ data.innodbIOReadWait.sum }}
{{ data.innodbIOReadWait.percentOfTotal }} of total
{{ data.innodbIOReadWait.percentOfQueryTime }} of query time
|
{{ metrics.InnoDB_IO_r_wait.Avg | humanize : 'time' }} avg
|
|
| Innodb Queue Wait |
{{ data.innodbQueueWait.avg }} (avg load) |
|
{{ data.innodbQueueWait.sum }}
{{ data.innodbQueueWait.percentOfTotal }} of total
{{ data.innodbQueueWait.percentOfQueryTime }} of query time
|
{{ metrics.InnoDB_queue_wait.Avg | humanize : 'time' }} avg
|
|
| Innodb Read Ops |
{{ data.innodbReadOps.perSec }} (per sec) |
|
{{ data.innodbReadOps.sum }}
{{ data.innodbReadOps.percentOfTotal }} of total
|
{{ metrics.InnoDB_IO_r_ops.Avg | humanize : 'number' }} avg
|
|
| Innodb Read Bytes |
{{ data.innodbReadBytes.perSec }} (per sec) |
|
{{ data.innodbReadBytes.sum }}
{{ data.innodbReadBytes.percentOfTotal }} of total
{{ data.innodbReadBytes.avgio }} avg io size
|
{{ metrics.InnoDB_IO_r_bytes.Avg | humanize : 'size' }} avg
|
|
| Innodb Distinct Pages |
- |
- |
{{ metrics.InnoDB_pages_distinct.Avg | humanize : 'number' }} avg
|
|
| Query Cache Hits |
{{ data.queryCacheHits.perSec }} (per sec) |
|
{{ data.queryCacheHits.sum }}
{{ data.queryCacheHits.percentOfTotal }} of total
{{ data.queryCacheHits.percentRation }} QC hit ratio
|
{{ metrics.QC_Hit.Avg | humanize : 'number' }} avg
|
|
| Rows Sent |
{{ data.rowsSent.perSec }} (per sec) |
|
{{ data.rowsSent.sum }}
{{ data.rowsSent.percentOfTotal }} of total
|
{{ metrics.Rows_sent.Avg | humanize : 'number' }} avg
|
|
| Bytes Sent |
{{ data.bytesSent.perSec }} (per sec) |
|
{{ data.bytesSent.sum }}
{{ data.bytesSent.percentOfTotal }} of total
{{ data.bytesSent.perRow }} bytes/row
|
{{ metrics.Bytes_sent.Avg | humanize : 'size' }} avg
|
|
| Rows Examined |
{{ data.rowsExamined.perSec }} (per sec) |
|
{{ data.rowsExamined.sum }}
{{ data.rowsExamined.percentOfTotal }} of total
{{ data.rowsExamined.perRow }} per row sent
|
{{ metrics.Rows_examined.Avg | humanize : 'number' }} avg
|
|
| Rows Affected |
{{ data.rowsAffected.perSec }} (per sec) |
|
{{ data.rowsAffected.sum }}
{{ data.rowsAffected.percentOfTotal }} of total
|
{{ metrics.Rows_affected.Avg | humanize : 'number' }} avg
|
|
| External Sorts (Filesort) |
{{ data.externalSorts.perSec }} (per sec) |
|
{{ data.externalSorts.sum }}
{{ data.externalSorts.percentOfTotal }} of total
{{ data.externalSorts.perQueries }} of queries
|
{{ metrics.Filesort.Avg | humanize : 'number' }} avg
|
|
| External Sorts of Disk (Filesort on disk) |
{{ data.externalSortsDisk.perSec }} (per sec) |
|
{{ data.externalSortsDisk.sum }}
{{ data.externalSortsDisk.percentOfTotal }} of total
{{ data.externalSortsDisk.perQueries }} of queries
|
{{ metrics.Filesort_on_disk.Avg | humanize : 'number' }} avg
|
|
| External Sort Passes (Merge Passes) |
{{ data.externalSortPasses.perSec }} (per sec) |
|
{{ data.externalSortPasses.sum }}
{{ data.externalSortPasses.percentOfTotal }} of total
{{ data.externalSortPasses.perExternalSort }} per external sort
|
{{ metrics.Merge_passes.Avg | humanize : 'number' }} avg
|
|
| Cartesian Products (Full Joins) |
{{ data.cartesianProducts.perSec }} (per sec) |
|
{{ data.cartesianProducts.sum }}
{{ data.cartesianProducts.percentOfTotal }} of total
{{ data.cartesianProducts.perQueries }} of queries
|
{{ metrics.Full_join.Avg | humanize : 'number' }} avg
|
|
| Full Table Scans |
{{ data.fullTableScans.perSec }} (per sec) |
|
{{ data.fullTableScans.sum }}
{{ data.fullTableScans.percentOfTotal }} of total
{{ data.fullTableScans.perQueries }} of queries
|
{{ metrics.Full_scan.Avg | humanize : 'number' }} avg
|
|
| Queries Requiring Tmp Table In Memory |
{{ data.queriesRequiringTmpTableInMemory.perSec }} (per sec) |
|
{{ data.queriesRequiringTmpTableInMemory.sum }}
{{ data.queriesRequiringTmpTableInMemory.percentOfTotal }} of total
{{ data.queriesRequiringTmpTableInMemory.perQueries }} of queries
|
{{ metrics.Tmp_table.Avg | humanize : 'number' }} avg
|
|
| Number of Tmp table in Memory |
{{ data.numberTmpTableMemory.perSec }} (per sec) |
|
{{ data.numberTmpTableMemory.sum }}
{{ data.numberTmpTableMemory.percentOfTotal }} of total
{{ data.numberTmpTableMemory.perQueryWithTmpTable }} per query with tmp table
|
{{ metrics.Tmp_tables.Avg | humanize : 'number' }} avg
|
|
| Queries Requiring Tmp Table on Disk |
{{ data.queriesRequiringTmpTableonDisk.perSec }} (per sec) |
|
{{ data.queriesRequiringTmpTableonDisk.sum }}
{{ data.queriesRequiringTmpTableonDisk.percentOfTotal }} of total
{{ data.queriesRequiringTmpTableInMemory.perQueries }} of queries
|
{{ metrics.Tmp_table_on_disk.Avg | humanize : 'number' }} avg
|
|
| Number of Tmp Tables on Disk |
{{ data.numberTmpTablesDisk.perSec }} (per sec) |
|
{{ data.numberTmpTablesDisk.sum }}
{{ data.numberTmpTablesDisk.percentOfTotal }} of total
{{ data.numberTmpTablesDisk.perQueryWithTmpTable }} per query with disk tmp table
|
{{ metrics.Tmp_disk_tables.Avg | humanize : 'number' }} avg
|
|
| Total Size of Tmp Tables |
{{ data.totalSizeTmpTables.perSec }} (per sec) |
|
{{ data.totalSizeTmpTables.sum }}
{{ data.totalSizeTmpTables.percentOfTotal }} of total
{{ data.totalSizeTmpTables.perQuery }} per query
|
{{ metrics.Tmp_table_sizes.Avg | humanize : 'size' }} avg
|
|