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 | 2007 | 938143558704 | 0 | 467435496 | 193450429920 | 1373 | 29523968 | 21503.2542 | 267 | 18333696 | 68665.5281 | 47857664 | |
sql/io_cache | 411 | 24030027120 | 0 | 58467024 | 11770989648 | 160 | 10516200 | 65726.2500 | 181 | 10516200 | 58100.5525 | 21032400 | |
innodb/innodb_temp_file | 572 | 605199552144 | 0 | 1058040984 | 25777420944 | 0 | 0 | 0.0000 | 499 | 9682944 | 19404.6974 | 9682944 | |
sql/ERRMSG | 55 | 43102460016 | 2540736 | 783680832 | 7199022336 | 33 | 3374704 | 102263.7576 | 0 | 0 | 0.0000 | 3374704 | |
innodb/innodb_log_file | 217 | 1112598498000 | 234432 | 5127182016 | 39397217904 | 8 | 70656 | 8832.0000 | 117 | 113152 | 967.1111 | 183808 | |
sql/binlog | 221 | 76508837856 | 0 | 346193760 | 16066870512 | 60 | 102233 | 1703.8833 | 5 | 681 | 136.2000 | 102914 | |
mysys/charset | 3 | 560751840 | 8120640 | 186917280 | 515862864 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog_index | 23 | 1296421632 | 0 | 56366112 | 410577552 | 5 | 160 | 32.0000 | 0 | 0 | 0.0000 | 160 | |
mysys/cnf | 5 | 196940832 | 380688 | 39388008 | 177573792 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 10894624224 | 1160544 | 2723656056 | 10659491568 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 16449312 | 826848 | 5483016 | 13439712 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 | 5 | |
sql/casetest | 15 | 967697808 | 0 | 64513152 | 864347616 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 16116144 | 0 | 8058072 | 11272272 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 6 | 430511136 | 0 | 71751768 | 400167504 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|