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 | 2002 | 8844330503184 | 4417747488 | 114949024608 | 1432685232 | 329061768288 | 8513836049664 | 8 | 70656 | 8832.0000 | 1336 | 2372096 | 1775.5210 | |
innodb/innodb_data_file | 4010 | 4522990042032 | 1127927592 | 679879651968 | 271717952352 | 66886342512 | 4184385747168 | 1578 | 30965760 | 19623.4221 | 1760 | 65683456 | 37320.1455 | |
innodb/innodb_temp_file | 276 | 812186840784 | 2942705832 | 37375926720 | 0 | 21604391952 | 790582448832 | 0 | 0 | 0.0000 | 192 | 5373952 | 27989.3333 | |
sql/io_cache | 170 | 664759027152 | 3910347144 | 464072007168 | 450379776 | 124580470608 | 539728176768 | 84 | 4060078 | 48334.2619 | 66 | 4060078 | 61516.3333 | |
sql/binlog | 193 | 486823850304 | 2522403312 | 27204531552 | 2142025248 | 3064022016 | 481617803040 | 28 | 708 | 25.2857 | 37 | 7272 | 196.5405 | |
sql/binlog_index | 38 | 45986038560 | 1210158840 | 29645548944 | 579655824 | 0 | 45406382736 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 40 | 35895195600 | 897379824 | 7904142576 | 16005280368 | 0 | 19889915232 | 24 | 2453852 | 102243.8333 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 8303239824 | 1037904912 | 7048165344 | 996322272 | 0 | 7306917552 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1803762048 | 360752304 | 1767272496 | 1768633152 | 0 | 35128896 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 857192688 | 57145968 | 777431424 | 0 | 0 | 857192688 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 9 | 832103712 | 92455968 | 555111216 | 557066928 | 0 | 275036784 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 311792448 | 103930728 | 279432912 | 279432912 | 0 | 32359536 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 167432496 | 55810656 | 152258304 | 0 | 0 | 167432496 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 7 | 44035200 | 6290592 | 10045728 | 0 | 0 | 44035200 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 40286928 | 10071600 | 16657872 | 0 | 0 | 40286928 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 17499504 | 5833080 | 13821456 | 0 | 2626800 | 14872704 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|