SELECT * FROM `x$io_global_by_wait_by_bytes`
|
event_name | total | total_latency | min_latency | avg_latency | max_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | total_requested | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_data_file | 2120 | 2399423155536 | 0 | 1131803112 | 204107782560 | 1251 | 25608192 | 20470.1775 | 547 | 26820608 | 49032.1901 | 52428800 | |
innodb/innodb_temp_file | 560 | 850261529568 | 0 | 1518323928 | 33646830096 | 0 | 0 | 0.0000 | 483 | 9682944 | 20047.5031 | 9682944 | |
sql/io_cache | 154 | 16421171184 | 0 | 106630920 | 12979834560 | 54 | 3971412 | 73544.6667 | 70 | 3971412 | 56734.4571 | 7942824 | |
sql/ERRMSG | 45 | 20450741520 | 2483184 | 454460688 | 2325812544 | 27 | 2772767 | 102695.0741 | 0 | 0 | 0.0000 | 2772767 | |
innodb/innodb_log_file | 382 | 2339382395328 | 232320 | 6124037568 | 283309614192 | 8 | 70656 | 8832.0000 | 212 | 189440 | 893.5849 | 260096 | |
mysys/charset | 3 | 278992032 | 1943568 | 92997168 | 267183312 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 193 | 90150883680 | 0 | 467102856 | 24051409536 | 44 | 772 | 17.5455 | 5 | 717 | 143.4000 | 1489 | |
sql/binlog_index | 38 | 79966011312 | 0 | 2104368552 | 42666337824 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 628430352 | 175824 | 125685912 | 607543200 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 20008032 | 806256 | 6669168 | 11877888 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1222589808 | 0 | 81505776 | 1157854368 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 215864352 | 0 | 71954784 | 199829520 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|