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 | 320 | 1843845609408 | 5762017272 | 101200504944 | 1783333728 | 45673137840 | 1796389137840 | 8 | 70656 | 8832.0000 | 183 | 162816 | 889.7049 | |
innodb/innodb_data_file | 1913 | 1529958130272 | 799768992 | 259060450704 | 219867836496 | 23230883808 | 1286859409968 | 1311 | 26591232 | 20283.1670 | 345 | 20824064 | 60359.6058 | |
innodb/innodb_temp_file | 127 | 634163675376 | 4993414536 | 40385741088 | 0 | 3811072848 | 630352602528 | 0 | 0 | 0.0000 | 54 | 2392064 | 44297.4815 | |
sql/binlog | 221 | 95246773776 | 430980792 | 28401295824 | 838003584 | 6123657408 | 88285112784 | 51 | 800 | 15.6863 | 5 | 647 | 129.4000 | |
sql/binlog_index | 38 | 53918901696 | 1418918424 | 34358271024 | 347061792 | 0 | 53571839904 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 50 | 38529693312 | 770593824 | 3268040160 | 21526581648 | 0 | 17003111664 | 30 | 3074944 | 102498.1333 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 2901300336 | 362662344 | 1479472368 | 1264217856 | 0 | 1637082480 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1132443312 | 75496080 | 1063537200 | 0 | 0 | 1132443312 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 989234928 | 197846880 | 966889968 | 968441760 | 0 | 20793168 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/data | 4 | 379822608 | 94955520 | 322978128 | 0 | 0 | 379822608 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 317165904 | 105721968 | 305109024 | 305109024 | 0 | 12056880 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 51918768 | 17306256 | 26897904 | 0 | 0 | 51918768 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 46780800 | 15593424 | 36986928 | 0 | 7144368 | 39636432 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|