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 | 1610 | 8042734525056 | 4995487200 | 125073982704 | 1192244592 | 255406169568 | 7786136110896 | 8 | 70656 | 8832.0000 | 1006 | 1506816 | 1497.8290 | |
innodb/innodb_data_file | 3193 | 4608462661968 | 1443301728 | 245195382960 | 190175119200 | 65869463088 | 4352418079680 | 1378 | 27688960 | 20093.5849 | 1249 | 49823744 | 39890.9079 | |
innodb/innodb_temp_file | 128 | 513297662592 | 4010137824 | 39035314560 | 0 | 1578722112 | 511718940480 | 0 | 0 | 0.0000 | 58 | 2260992 | 38982.6207 | |
sql/binlog | 439 | 415697706864 | 946919424 | 24892198320 | 1285651488 | 1090684320 | 413321371056 | 93 | 968 | 10.4086 | 30 | 14005 | 466.8333 | |
sql/binlog_index | 38 | 43323090096 | 1140081096 | 26377545216 | 716078352 | 0 | 42607011744 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 23103702336 | 420067296 | 3160976544 | 16019279760 | 0 | 7084422576 | 33 | 3391409 | 102769.9697 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 929067744 | 61937832 | 804072192 | 0 | 0 | 929067744 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 704283888 | 140856672 | 685674000 | 686929056 | 0 | 17354832 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 511410768 | 63926280 | 213491520 | 374285472 | 0 | 137125296 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 225954432 | 75318144 | 210361536 | 210361536 | 0 | 15592896 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 5 | 193440720 | 38688144 | 158440656 | 0 | 0 | 193440720 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 177989856 | 44497464 | 143681472 | 0 | 0 | 177989856 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 13593888 | 4531296 | 11100144 | 0 | 1818432 | 11775456 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|