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 | 2072 | 1312890082416 | 0 | 633634056 | 193056931056 | 1405 | 28278784 | 20127.2484 | 386 | 22069248 | 57174.2176 | 50348032 | |
sql/io_cache | 312 | 42168301824 | 0 | 135154800 | 17595547728 | 144 | 7835600 | 54413.8889 | 128 | 7835600 | 61215.6250 | 15671200 | |
innodb/innodb_temp_file | 462 | 472179566496 | 0 | 1022033496 | 29502869616 | 0 | 0 | 0.0000 | 395 | 7585792 | 19204.5367 | 7585792 | |
sql/ERRMSG | 60 | 34557002304 | 2296800 | 575949792 | 2956286256 | 36 | 3685689 | 102380.2500 | 0 | 0 | 0.0000 | 3685689 | |
innodb/innodb_log_file | 351 | 1828442940192 | 229152 | 5209239024 | 38494524288 | 8 | 70656 | 8832.0000 | 204 | 184832 | 906.0392 | 255488 | |
mysys/charset | 3 | 255759504 | 2169024 | 85252992 | 243990912 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 167 | 101796789600 | 0 | 609561480 | 20802262272 | 38 | 7267 | 191.2368 | 7 | 1377 | 196.7143 | 8644 | |
sql/binlog_index | 23 | 1687327488 | 0 | 73361904 | 426533184 | 5 | 160 | 32.0000 | 0 | 0 | 0.0000 | 160 | |
mysys/cnf | 5 | 167694384 | 215424 | 33538824 | 152746176 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 26642880 | 1858032 | 8880960 | 20526000 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1153361616 | 0 | 76890528 | 1088362176 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 57339216 | 0 | 19113072 | 30623472 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|