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 | 1520 | 7549913922672 | 4967048592 | 119157586944 | 986586480 | 185800264320 | 7363127071872 | 8 | 70656 | 8832.0000 | 909 | 844800 | 929.3729 | |
innodb/innodb_data_file | 4160 | 3473515405008 | 834979464 | 77561821392 | 235483412736 | 60932712192 | 3177099280080 | 1644 | 32931840 | 20031.5328 | 1928 | 70828032 | 36736.5311 | |
innodb/innodb_temp_file | 401 | 769378196400 | 1918648776 | 35522260224 | 0 | 6240226080 | 763137970320 | 0 | 0 | 0.0000 | 309 | 7815168 | 25291.8058 | |
sql/binlog | 1245 | 204948037008 | 164616672 | 19981291968 | 14057868000 | 1526374080 | 189363794928 | 322 | 212281 | 659.2578 | 14 | 3949 | 282.0714 | |
sql/ERRMSG | 40 | 20856780384 | 521419272 | 3363210576 | 10096763424 | 0 | 10760016960 | 24 | 2466220 | 102759.1667 | 0 | 0 | 0.0000 | |
myisam/kfile | 24 | 2057909040 | 85746144 | 882955920 | 1965596688 | 0 | 92312352 | 12 | 2346 | 195.5000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1132472880 | 226494576 | 1104593952 | 1105895472 | 0 | 26577408 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 982810224 | 65520576 | 902149776 | 0 | 0 | 982810224 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/binlog_index | 23 | 970281840 | 42186144 | 241050480 | 541087008 | 0 | 429194832 | 5 | 288 | 57.6000 | 0 | 0 | 0.0000 | |
sql/io_cache | 38 | 795173808 | 20925432 | 61120752 | 106492848 | 399729792 | 288951168 | 10 | 1026630 | 102663.0000 | 18 | 1026630 | 57035.0000 | |
myisam/dfile | 81 | 716523984 | 8845848 | 238929504 | 232991088 | 0 | 483532896 | 50 | 2973 | 59.4600 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 357815040 | 119271504 | 344602368 | 344602368 | 0 | 13212672 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 2 | 21985392 | 10992696 | 16185312 | 0 | 0 | 21985392 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 17021136 | 5673624 | 13232208 | 0 | 2870736 | 14150400 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 |
|