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 | 11417 | 51978651062976 | 4552741512 | 145649519664 | 1192244592 | 1672157151456 | 50305301666928 | 8 | 70656 | 8832.0000 | 7314 | 11523584 | 1575.5515 | |
innodb/innodb_data_file | 12289 | 21293886966000 | 1732759776 | 332113968912 | 216893120400 | 332628410400 | 20744365435200 | 1432 | 28573696 | 19953.6983 | 8358 | 278970368 | 33377.6463 | |
sql/binlog | 1612 | 2287244891712 | 1418886216 | 36585240912 | 2726472144 | 7010824656 | 2277507594912 | 317 | 1864 | 5.8801 | 172 | 157572 | 916.1163 | |
innodb/innodb_temp_file | 558 | 1463814447744 | 2623323120 | 39035314560 | 0 | 35322971904 | 1428491475840 | 0 | 0 | 0.0000 | 430 | 12156928 | 28271.9256 | |
sql/binlog_index | 38 | 43323090096 | 1140081096 | 26377545216 | 716078352 | 0 | 42607011744 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 70 | 32140684752 | 459152496 | 5403006048 | 18817379328 | 0 | 13323305424 | 42 | 4304471 | 102487.4048 | 0 | 0 | 0.0000 | |
sql/io_cache | 82 | 2210635152 | 26958888 | 505066848 | 176723184 | 1020724848 | 1013187120 | 24 | 2084370 | 86848.7500 | 38 | 2084370 | 54851.8421 | |
sql/misc | 15 | 1193222448 | 79547952 | 371421600 | 0 | 0 | 1193222448 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 9 | 1169201088 | 129911232 | 965717808 | 969349392 | 0 | 199851696 | 2 | 0 | 0.0000 | 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/pid | 3 | 13593888 | 4531296 | 11100144 | 0 | 1818432 | 11775456 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|