SELECT * FROM `x$io_global_by_wait_by_latency`
|
event_name | total | total_latency | avg_latency | max_latency | read_latency | write_latency | misc_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_log_file | 481 | 3071069605296 | 6384760008 | 117525948672 | 1380015120 | 102264702672 | 2967424887504 | 8 | 70656 | 8832.0000 | 279 | 288256 | 1033.1756 | |
innodb/innodb_data_file | 2268 | 2838292510944 | 1251451608 | 218184668592 | 268798766544 | 53879892528 | 2515613851872 | 1241 | 25444352 | 20503.1039 | 675 | 31145984 | 46142.1985 | |
innodb/innodb_temp_file | 90 | 364667211216 | 4051857744 | 26518742976 | 0 | 3298199520 | 361369011696 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | |
sql/binlog | 275 | 171341093088 | 623058480 | 17875616352 | 1216765968 | 623352048 | 169500975072 | 61 | 840 | 13.7705 | 12 | 2712 | 226.0000 | |
sql/binlog_index | 38 | 56285301600 | 1481192064 | 34313706768 | 546696480 | 0 | 55738605120 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 90 | 49315312464 | 547947840 | 3291258432 | 32240460912 | 0 | 17074851552 | 54 | 5521448 | 102249.0370 | 0 | 0 | 0.0000 | |
sql/io_cache | 240 | 20654913840 | 86061888 | 16484926656 | 372926400 | 1884570336 | 18397417104 | 64 | 4462592 | 69728.0000 | 96 | 4392608 | 45756.3333 | |
myisam/dfile | 218 | 996866112 | 4572744 | 500067216 | 865104240 | 0 | 131761872 | 202 | 32934 | 163.0396 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 903843072 | 60256152 | 829747248 | 0 | 0 | 903843072 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 727498992 | 145499640 | 708343680 | 709945632 | 0 | 17553360 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/kfile | 8 | 701739456 | 87717432 | 334952112 | 648615792 | 0 | 53123664 | 4 | 854 | 213.5000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 273868848 | 91289616 | 256236816 | 256236816 | 0 | 17632032 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 5 | 259734288 | 51946752 | 190536720 | 0 | 0 | 259734288 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 47887488 | 15962496 | 34408176 | 0 | 10527264 | 37360224 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|