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 | 1552 | 781036599330 | 0 | 503245070 | 270295673080 | 1188 | 24576000 | 20686.8687 | 195 | 16269312 | 83432.3692 | 40845312 | |
sql/io_cache | 150 | 15900527880 | 0 | 106003445 | 8807872840 | 54 | 3705414 | 68618.7778 | 66 | 3705414 | 56142.6364 | 7410828 | |
innodb/innodb_temp_file | 273 | 446301550410 | 0 | 1634804080 | 31092948730 | 0 | 0 | 0.0000 | 210 | 4292608 | 20440.9905 | 4292608 | |
sql/ERRMSG | 20 | 447072772490 | 2569970 | 22353638545 | 418456812680 | 12 | 1217615 | 101467.9167 | 0 | 0 | 0.0000 | 1217615 | |
innodb/innodb_log_file | 99 | 1052381057610 | 239030 | 10630111685 | 481281253080 | 8 | 70656 | 8832.0000 | 53 | 70656 | 1333.1321 | 141312 | |
mysys/charset | 3 | 274994740 | 2430050 | 91664825 | 253426390 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 69 | 47571299570 | 0 | 689439105 | 21033854540 | 14 | 652 | 46.5714 | 3 | 156 | 52.0000 | 808 | |
sql/binlog_index | 38 | 59725884970 | 0 | 1571733815 | 38889092910 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1757517100 | 155290 | 351503420 | 1741222780 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 55831260 | 2857760 | 18610420 | 34769590 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1017700700 | 0 | 67846625 | 954987390 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 9389480 | 0 | 9389480 | 9389480 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|