SELECT * FROM `x$io_global_by_wait_by_latency`
|
event_name | total | total_latency | avg_latency | max_latency | read_latency | write_latency | misc_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_log_file | 743 | 4524398320464 | 6089365128 | 97481913936 | 1895215872 | 84147384288 | 4438355720304 | 8 | 70656 | 8832.0000 | 422 | 332800 | 788.6256 | |
innodb/innodb_data_file | 3029 | 4097912036064 | 1352892552 | 275911629312 | 374155213872 | 64112721024 | 3659644101168 | 1636 | 31916032 | 19508.5770 | 855 | 35962880 | 42061.8480 | |
innodb/innodb_temp_file | 549 | 1752462482496 | 3192098976 | 131486764464 | 0 | 281122111776 | 1471340370720 | 0 | 0 | 0.0000 | 433 | 11419648 | 26373.3210 | |
sql/io_cache | 1498 | 193338817056 | 129064584 | 77751117840 | 2943237264 | 19558254144 | 170837325648 | 704 | 35523804 | 50459.9489 | 604 | 35523804 | 58814.2450 | |
sql/binlog | 335 | 88511908848 | 264214632 | 31874442336 | 4936094064 | 1364519904 | 82211294880 | 80 | 916 | 11.4500 | 4 | 411 | 102.7500 | |
sql/binlog_index | 38 | 61290570000 | 1612909584 | 31150613472 | 2375755536 | 0 | 58914814464 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 65 | 41356011312 | 636246072 | 3242749488 | 23141855088 | 0 | 18214156224 | 39 | 3991856 | 102355.2821 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 12334242096 | 1541780064 | 11409569424 | 771516240 | 0 | 11562725856 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 12 | 4499651904 | 374970816 | 3403342800 | 4453669440 | 0 | 45982464 | 6 | 1241 | 206.8333 | 0 | 0 | 0.0000 | |
csv/data | 4 | 1731714864 | 432928584 | 1657359264 | 0 | 0 | 1731714864 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 709259232 | 47283720 | 650700864 | 0 | 0 | 709259232 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 589812960 | 117962592 | 574031568 | 575369520 | 0 | 14443440 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 280787760 | 93595920 | 270593664 | 270593664 | 0 | 10194096 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 59988720 | 19996152 | 38636400 | 0 | 18041760 | 41946960 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 2 | 41816544 | 20908272 | 28190448 | 0 | 0 | 41816544 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 6 | 23799600 | 3966600 | 8979168 | 0 | 0 | 23799600 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|