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 | 469 | 2464140943440 | 5254031640 | 71380015872 | 1431696816 | 58013796720 | 2404695449904 | 8 | 70656 | 8832.0000 | 271 | 228864 | 844.5166 | |
innodb/innodb_data_file | 2082 | 1088685645696 | 522903744 | 249264631968 | 248157957168 | 24628963920 | 815898724608 | 1327 | 26853376 | 20236.1537 | 495 | 25935872 | 52395.7010 | |
innodb/innodb_temp_file | 97 | 415968477408 | 4288334688 | 25878798000 | 0 | 3486122112 | 412482355296 | 0 | 0 | 0.0000 | 34 | 1409024 | 41441.8824 | |
sql/binlog_index | 38 | 55647375696 | 1464404568 | 33043272240 | 1829628240 | 0 | 53817747456 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 69 | 36059597904 | 522602784 | 16596255456 | 1267892736 | 46271808 | 34745433360 | 14 | 652 | 46.5714 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 20 | 11489823312 | 574490928 | 3228559488 | 7017930480 | 0 | 4471892832 | 12 | 1232364 | 102697.0000 | 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 | 20 | 843638928 | 42181920 | 777377568 | 778248768 | 0 | 65390160 | 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 |
|