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 | 1043 | 5227156582170 | 5011655355 | 105733402580 | 826736400 | 110760905730 | 5115568940040 | 8 | 70656 | 8832.0000 | 620 | 500736 | 807.6387 | |
innodb/innodb_data_file | 3191 | 2070580367300 | 648881120 | 75049755890 | 189260751210 | 37444366440 | 1843875249650 | 1571 | 31244288 | 19888.1528 | 1238 | 49201152 | 39742.4491 | |
innodb/innodb_temp_file | 614 | 875221248910 | 1425441625 | 34208436070 | 0 | 24231200380 | 850990048530 | 0 | 0 | 0.0000 | 522 | 11304960 | 21657.0115 | |
sql/binlog | 417 | 153389101470 | 367839345 | 35593871970 | 7449016970 | 6043081730 | 139897002770 | 101 | 35853 | 354.9802 | 9 | 1873 | 208.1111 | |
sql/io_cache | 420 | 13569792990 | 32308800 | 2582766850 | 1103044480 | 4785566630 | 7681181880 | 220 | 9679028 | 43995.5818 | 160 | 9679028 | 60493.9250 | |
sql/ERRMSG | 35 | 13311464630 | 380327470 | 1278134750 | 8535150740 | 0 | 4776313890 | 21 | 2147518 | 102262.7619 | 0 | 0 | 0.0000 | |
sql/binlog_index | 23 | 2418022710 | 105131330 | 1829566360 | 2053546480 | 0 | 364476230 | 5 | 224 | 44.8000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 825128910 | 55008435 | 731180050 | 0 | 0 | 825128910 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 6 | 407115790 | 67852455 | 210402580 | 0 | 0 | 407115790 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 296839220 | 98946230 | 283796980 | 283796980 | 0 | 13042240 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 226787530 | 56696750 | 201453530 | 203249700 | 0 | 23537830 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 226169550 | 45233910 | 203949830 | 204824330 | 0 | 21345220 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/dfile | 4 | 44141050 | 11035130 | 22463520 | 0 | 0 | 44141050 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 25406080 | 8468605 | 21804200 | 0 | 2745930 | 22660150 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 |
|