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 | 3537 | 2928362395728 | 0 | 827922480 | 212227573008 | 1453 | 28917760 | 19902.1060 | 1433 | 55427072 | 38679.0454 | 84344832 | |
sql/ERRMSG | 50 | 60557174304 | 2694384 | 1211143296 | 24960319824 | 30 | 3077203 | 102573.4333 | 0 | 0 | 0.0000 | 3077203 | |
innodb/innodb_log_file | 1912 | 8194388500848 | 239712 | 4285767816 | 150927402384 | 8 | 70656 | 8832.0000 | 1283 | 2298880 | 1791.8005 | 2369536 | |
innodb/innodb_temp_file | 123 | 577683020640 | 0 | 4696609896 | 43780112112 | 0 | 0 | 0.0000 | 52 | 2228224 | 42850.4615 | 2228224 | |
mysys/charset | 3 | 358809792 | 2439360 | 119603088 | 329934528 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 295 | 454023251616 | 0 | 1539061656 | 20046995760 | 55 | 816 | 14.8364 | 34 | 6538 | 192.2941 | 7354 | |
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 | |
mysys/cnf | 5 | 573747504 | 155232 | 114749448 | 554517216 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 504854592 | 703296 | 126213648 | 408988800 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
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 | 2 | 39746784 | 0 | 19873392 | 34418736 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 9 | 51525408 | 0 | 5724840 | 17335824 | 3 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 7 | 228639840 | 0 | 32662608 | 171033984 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|