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_data_file | 1909 | 1479521737056 | 775024272 | 190523080176 | 151672790016 | 16499972544 | 1311348974496 | 1292 | 26673152 | 20644.8545 | 317 | 19546112 | 61659.6593 | |
innodb/innodb_log_file | 258 | 1458272782032 | 5652219936 | 39607370352 | 865156512 | 25544783616 | 1431862841904 | 8 | 70656 | 8832.0000 | 139 | 152576 | 1097.6691 | |
innodb/innodb_temp_file | 116 | 490080150384 | 4224828696 | 40085938464 | 0 | 2098176960 | 487981973424 | 0 | 0 | 0.0000 | 47 | 2015232 | 42877.2766 | |
sql/binlog | 167 | 147170292720 | 881259192 | 18637451184 | 1369909728 | 2856507984 | 142943875008 | 36 | 12704 | 352.8889 | 11 | 2343 | 213.0000 | |
sql/ERRMSG | 30 | 20820903840 | 694030128 | 3277559472 | 9754772544 | 0 | 11066131296 | 18 | 1830612 | 101700.6667 | 0 | 0 | 0.0000 | |
sql/io_cache | 56 | 13492223712 | 240932472 | 11727729024 | 319246752 | 746558208 | 12426418752 | 20 | 1538252 | 76912.6000 | 26 | 1538252 | 59163.5385 | |
sql/binlog_index | 23 | 865422096 | 37626864 | 294262848 | 238288512 | 0 | 627133584 | 5 | 160 | 32.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 766086816 | 51072384 | 685798080 | 0 | 0 | 766086816 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 368283168 | 73656528 | 352594704 | 353738880 | 0 | 14544288 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 353412576 | 88353144 | 197798304 | 197798304 | 0 | 155614272 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 296940864 | 98980200 | 281417664 | 281417664 | 0 | 15523200 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 6 | 283230288 | 47205048 | 266123616 | 5833872 | 0 | 277396416 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 6 | 200817408 | 33469392 | 158218896 | 0 | 0 | 200817408 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 18169008 | 6056160 | 14573328 | 0 | 2662176 | 15506832 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 |
|