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 | 516 | 2770800523392 | 5369768448 | 71380015872 | 1431696816 | 58393883856 | 2710974942720 | 8 | 70656 | 8832.0000 | 297 | 249856 | 841.2660 | |
innodb/innodb_data_file | 2156 | 1330059068448 | 616910448 | 249264631968 | 256500638064 | 25257899040 | 1048300531344 | 1342 | 27099136 | 20193.0969 | 523 | 26689536 | 51031.6176 | |
innodb/innodb_temp_file | 100 | 431778755232 | 4317787320 | 25878798000 | 0 | 3560074848 | 428218680384 | 0 | 0 | 0.0000 | 36 | 1507328 | 41870.2222 | |
sql/binlog_index | 38 | 55647375696 | 1464404568 | 33043272240 | 1829628240 | 0 | 53817747456 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 89 | 36175517664 | 406466280 | 16596255456 | 1281948624 | 46271808 | 34847297232 | 19 | 672 | 35.3684 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 25 | 12855759312 | 514230288 | 3228559488 | 7842809040 | 0 | 5012950272 | 15 | 1538831 | 102588.7333 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 3918337632 | 244895904 | 2276250768 | 3860282976 | 0 | 58054656 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 1349741712 | 337435296 | 1020158832 | 1020158832 | 0 | 329582880 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1005891216 | 67059168 | 943794720 | 0 | 0 | 1005891216 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 22 | 862885056 | 39221952 | 777377568 | 778248768 | 0 | 84636288 | 2 | 123 | 61.5000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 534208752 | 106841592 | 515442048 | 516496464 | 0 | 17712288 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 239110608 | 79703448 | 226944960 | 226944960 | 0 | 12165648 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 54429936 | 18143136 | 34898688 | 0 | 16403904 | 38026032 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
csv/data | 2 | 48638304 | 24319152 | 35929872 | 0 | 0 | 48638304 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 1 | 13137168 | 13137168 | 13137168 | 0 | 0 | 13137168 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|