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 | 2576 | 2782036734048 | 0 | 1079983080 | 204262371456 | 1521 | 30031872 | 19744.8205 | 664 | 30588928 | 46067.6627 | 60620800 | |
sql/io_cache | 408 | 11224410912 | 0 | 27510648 | 2120145456 | 208 | 9596548 | 46137.2500 | 160 | 9596548 | 59978.4250 | 19193096 | |
innodb/innodb_temp_file | 534 | 1598523536016 | 0 | 2993489664 | 63283269456 | 0 | 0 | 0.0000 | 405 | 11812864 | 29167.5654 | 11812864 | |
sql/ERRMSG | 80 | 49659420624 | 3107808 | 620742672 | 2495444160 | 48 | 4913267 | 102359.7292 | 0 | 0 | 0.0000 | 4913267 | |
innodb/innodb_log_file | 553 | 3426161848032 | 246576 | 6195590808 | 68398186560 | 8 | 70656 | 8832.0000 | 315 | 276480 | 877.7143 | 347136 | |
mysys/charset | 3 | 298952544 | 3338016 | 99650760 | 278381664 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 373 | 79448348496 | 0 | 212998104 | 21614720160 | 89 | 952 | 10.6966 | 5 | 658 | 131.6000 | 1610 | |
myisam/kfile | 4 | 537744768 | 1392864 | 134436192 | 493440288 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 45087803376 | 0 | 1186521072 | 27259633632 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 1704945792 | 838464 | 213118224 | 563820576 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1081851408 | 249744 | 216370176 | 1052886384 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 59128608 | 3241920 | 19709448 | 43120704 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 921540048 | 0 | 61435968 | 839877984 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 32121936 | 0 | 16060968 | 18931440 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 139 | 16390368192 | 0 | 117916128 | 15815006064 | 63 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 20512800 | 784608 | 10256400 | 19728192 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|