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 | 2983 | 13614757081728 | 4564115424 | 114949024608 | 1432685232 | 515923547568 | 13097400848928 | 8 | 70656 | 8832.0000 | 1965 | 3285504 | 1672.0122 | |
innodb/innodb_data_file | 4949 | 6850654025424 | 1384249944 | 679879651968 | 272075221440 | 87076260480 | 6491502543504 | 1579 | 30982144 | 19621.3705 | 2433 | 87539712 | 35980.1529 | |
innodb/innodb_temp_file | 578 | 997315269456 | 1725458856 | 37375926720 | 0 | 25525599264 | 971789670192 | 0 | 0 | 0.0000 | 481 | 10960896 | 22787.7256 | |
sql/binlog | 399 | 789041905344 | 1977548496 | 27204531552 | 3716689680 | 5535403632 | 779789812032 | 69 | 872 | 12.6377 | 58 | 16486 | 284.2414 | |
sql/io_cache | 390 | 681719621088 | 1747998912 | 464072007168 | 1046666544 | 127510636176 | 553162318368 | 186 | 9182086 | 49366.0538 | 154 | 9182086 | 59623.9351 | |
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 |
|