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 | 2992 | 13668603557136 | 4568383512 | 114949024608 | 1432685232 | 516693314544 | 13150477557360 | 8 | 70656 | 8832.0000 | 1970 | 3288064 | 1669.0680 | |
innodb/innodb_data_file | 4961 | 6889574935056 | 1388747184 | 679879651968 | 272075221440 | 87369391296 | 6530130322320 | 1579 | 30982144 | 19621.3705 | 2440 | 87736320 | 35957.5082 | |
innodb/innodb_temp_file | 581 | 1012303853616 | 1742347200 | 37375926720 | 0 | 25598268432 | 986705585184 | 0 | 0 | 0.0000 | 483 | 11059200 | 22896.8944 | |
sql/binlog | 407 | 789294132000 | 1939297536 | 27204531552 | 3919414752 | 5535403632 | 779839313616 | 71 | 880 | 12.3944 | 58 | 16486 | 284.2414 | |
sql/io_cache | 427 | 682937614128 | 1599385392 | 464072007168 | 1138753968 | 127812380784 | 553986479376 | 203 | 10046064 | 49488.0000 | 169 | 10046064 | 59444.1657 | |
sql/ERRMSG | 65 | 50041250160 | 769865184 | 7904142576 | 23910205968 | 0 | 26131044192 | 39 | 3990814 | 102328.5641 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 45986038560 | 1210158840 | 29645548944 | 579655824 | 0 | 45406382736 | 9 | 288 | 32.0000 | 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 | 7 | 216477360 | 30925224 | 152258304 | 0 | 0 | 216477360 | 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 |
|