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 | 433 | 2505359742864 | 5786049984 | 147445509552 | 1121912352 | 82358598432 | 2421879232080 | 8 | 70656 | 8832.0000 | 244 | 205824 | 843.5410 | |
innodb/innodb_data_file | 2235 | 2257641486144 | 1010130264 | 222775784880 | 184059455184 | 29621258832 | 2043960772128 | 1305 | 26492928 | 20301.0943 | 578 | 27869184 | 48216.5813 | |
innodb/innodb_temp_file | 690 | 1157944353456 | 1678180152 | 41628665760 | 0 | 27904605168 | 1130039748288 | 0 | 0 | 0.0000 | 588 | 13041664 | 22179.7007 | |
sql/binlog_index | 38 | 47432794992 | 1248231336 | 26943374832 | 360801408 | 0 | 47071993584 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 47329460112 | 788824080 | 5312789328 | 22332238896 | 0 | 24997221216 | 36 | 3686455 | 102401.5278 | 0 | 0 | 0.0000 | |
sql/binlog | 225 | 42994682544 | 191087424 | 19664604960 | 3208823904 | 45213168 | 39740645472 | 53 | 808 | 15.2453 | 3 | 156 | 52.0000 | |
sql/io_cache | 56 | 17227423488 | 307632336 | 15534892032 | 122789568 | 871014672 | 16233619248 | 20 | 1513508 | 75675.4000 | 26 | 1513508 | 58211.8462 | |
sql/casetest | 15 | 917246880 | 61149792 | 842346384 | 0 | 0 | 917246880 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 678474720 | 135694944 | 648228240 | 649547184 | 0 | 28927536 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 269424144 | 89808048 | 252202368 | 252202368 | 0 | 17221776 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 48376944 | 16125648 | 37272576 | 0 | 8326560 | 40050384 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 5717184 | 5717184 | 5717184 | 0 | 0 | 5717184 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|