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 | 4322 | 4773679354224 | 0 | 1104506832 | 212227573008 | 1525 | 30097408 | 19736.0052 | 1948 | 70795264 | 36342.5380 | 100892672 | |
innodb/innodb_temp_file | 228 | 1195190740128 | 0 | 5242064520 | 43780112112 | 0 | 0 | 0.0000 | 124 | 5570560 | 44923.8710 | 5570560 | |
sql/ERRMSG | 70 | 68074650864 | 2694384 | 972494952 | 24960319824 | 42 | 4304171 | 102480.2619 | 0 | 0 | 0.0000 | 4304171 | |
innodb/innodb_log_file | 2364 | 10950181772112 | 239712 | 4632056352 | 150927402384 | 8 | 70656 | 8832.0000 | 1542 | 2477056 | 1606.3917 | 2547712 | |
sql/io_cache | 30 | 640130832 | 0 | 21337536 | 57673440 | 8 | 557824 | 69728.0000 | 12 | 549076 | 45756.3333 | 1106900 | |
mysys/charset | 3 | 358809792 | 2439360 | 119603088 | 329934528 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 825 | 505635355104 | 0 | 612891312 | 20046995760 | 186 | 1340 | 7.2043 | 37 | 7301 | 197.3243 | 8641 | |
myisam/kfile | 9 | 1362976560 | 0 | 151441752 | 633151728 | 2 | 392 | 196.0000 | 0 | 0 | 0.0000 | 392 | |
sql/binlog_index | 38 | 42042741840 | 0 | 1106387832 | 25254459648 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 1056640464 | 703296 | 132079992 | 476976192 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 573747504 | 155232 | 114749448 | 554517216 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 18692256 | 1305744 | 6230664 | 13090176 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1508866656 | 0 | 100590864 | 1427685072 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 5 | 1921205616 | 0 | 384240912 | 1844778144 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 22 | 125968656 | 0 | 5725632 | 28129200 | 8 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 7 | 228639840 | 0 | 32662608 | 171033984 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|