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 | 2544 | 12091279142448 | 4752861168 | 974415374064 | 1736898240 | 311021044752 | 11778521199456 | 8 | 70656 | 8832.0000 | 1662 | 2617344 | 1574.8159 | |
innodb/innodb_data_file | 4588 | 5092212046944 | 1109897976 | 258297297456 | 338988942864 | 88770099792 | 4664453004288 | 1523 | 30064640 | 19740.4071 | 2293 | 82231296 | 35861.8823 | |
innodb/innodb_temp_file | 337 | 976179095760 | 2896673736 | 78052379856 | 0 | 69566748768 | 906612346992 | 0 | 0 | 0.0000 | 253 | 6373376 | 25191.2095 | |
sql/binlog | 485 | 514944734304 | 1061741472 | 32007107616 | 1457388768 | 1840342416 | 511647003120 | 100 | 996 | 9.9600 | 39 | 7764 | 199.0769 | |
sql/binlog_index | 38 | 59304219216 | 1560637320 | 36945909792 | 795048672 | 0 | 58509170544 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 28846676496 | 524484840 | 3021890784 | 17214407760 | 0 | 11632268736 | 33 | 3382346 | 102495.3333 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 1166240064 | 145780008 | 475039488 | 760286736 | 0 | 405953328 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 986604432 | 65773488 | 922901232 | 0 | 0 | 986604432 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 733137504 | 146627448 | 699411504 | 702467568 | 0 | 30669936 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/data | 4 | 727703856 | 181925832 | 649537680 | 0 | 0 | 727703856 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 9 | 615841248 | 68426688 | 256529856 | 241392624 | 0 | 374448624 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 316897680 | 105632472 | 302922576 | 302922576 | 0 | 13975104 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 57048288 | 19015920 | 43457040 | 0 | 10101168 | 46947120 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 7 | 50492640 | 7213008 | 18353280 | 0 | 0 | 50492640 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 47679984 | 11919864 | 15630384 | 0 | 0 | 47679984 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|