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 | 3964 | 3977526255120 | 0 | 1003412256 | 212227573008 | 1472 | 29229056 | 19856.6957 | 1723 | 64077824 | 37189.6831 | 93306880 | |
innodb/innodb_temp_file | 198 | 989449638144 | 0 | 4997220360 | 43780112112 | 0 | 0 | 0.0000 | 104 | 4587520 | 44110.7692 | 4587520 | |
sql/ERRMSG | 55 | 64453234032 | 2694384 | 1171876728 | 24960319824 | 33 | 3382422 | 102497.6364 | 0 | 0 | 0.0000 | 3382422 | |
innodb/innodb_log_file | 2214 | 9968185664448 | 239712 | 4502342064 | 150927402384 | 8 | 70656 | 8832.0000 | 1457 | 2413056 | 1656.1812 | 2483712 | |
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 | 589 | 471197810688 | 0 | 799996032 | 20046995760 | 128 | 1108 | 8.6563 | 35 | 6785 | 193.8571 | 7893 | |
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 | 3 | 1884524928 | 0 | 628174800 | 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 |
|