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 | 653 | 3875462250528 | 5934857808 | 274770808224 | 1282554768 | 173547904992 | 3700631790768 | 8 | 70656 | 8832.0000 | 386 | 308224 | 798.5078 | |
innodb/innodb_data_file | 2294 | 1851151127232 | 806953224 | 215713337664 | 184582499904 | 26249013648 | 1640319613680 | 1326 | 26836992 | 20239.0588 | 702 | 32096256 | 45721.1624 | |
innodb/innodb_temp_file | 108 | 423783770256 | 3923923608 | 28712490576 | 0 | 1406733504 | 422377036752 | 0 | 0 | 0.0000 | 43 | 1687552 | 39245.3953 | |
sql/binlog | 183 | 94303350240 | 515318760 | 20735355696 | 3271982736 | 12682695168 | 78348672336 | 41 | 760 | 18.5366 | 6 | 908 | 151.3333 | |
sql/binlog_index | 38 | 55021913760 | 1447944960 | 35059058496 | 472711536 | 0 | 54549202224 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 45 | 17276712288 | 383926752 | 1952149584 | 12560723472 | 0 | 4715988816 | 27 | 2777956 | 102887.2593 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1098153936 | 73210104 | 980356080 | 0 | 0 | 1098153936 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 865630128 | 108203568 | 429928752 | 644188512 | 0 | 221441616 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 576322032 | 115264248 | 549733008 | 551720400 | 0 | 24601632 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 285941568 | 71485392 | 242633424 | 0 | 0 | 285941568 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 244469280 | 61117320 | 204447936 | 0 | 0 | 244469280 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 243054768 | 81018168 | 216931440 | 216931440 | 0 | 26123328 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 21464784 | 7154928 | 16901280 | 0 | 3333264 | 18131520 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|