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 | 2664 | 3093133279104 | 0 | 1161085992 | 204262371456 | 1521 | 30031872 | 19744.8205 | 726 | 32522240 | 44796.4738 | 62554112 | |
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 | 606 | 3775043308608 | 246576 | 6229444320 | 68398186560 | 8 | 70656 | 8832.0000 | 347 | 315904 | 910.3862 | 386560 | |
mysys/charset | 3 | 298952544 | 3338016 | 99650760 | 278381664 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 379 | 96646991760 | 0 | 255004992 | 21614720160 | 90 | 956 | 10.6222 | 6 | 953 | 158.8333 | 1909 | |
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 |
|