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 | 906 | 5419229353296 | 5981489184 | 48858985824 | 1260667584 | 56870693088 | 5361097992624 | 8 | 70656 | 8832.0000 | 512 | 384000 | 750.0000 | |
innodb/innodb_data_file | 3063 | 5317993657152 | 1736204184 | 207547856208 | 330564141072 | 52089517920 | 4935339998160 | 1347 | 27181056 | 20178.9577 | 1055 | 41467904 | 39306.0701 | |
innodb/innodb_temp_file | 144 | 605982215520 | 4208209632 | 30366357120 | 0 | 2886347376 | 603095868144 | 0 | 0 | 0.0000 | 67 | 2867200 | 42794.0299 | |
sql/ERRMSG | 75 | 68169625392 | 908928240 | 6019474032 | 40076594448 | 0 | 28093030944 | 45 | 4609572 | 102434.9333 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 54811361088 | 1442404128 | 32122324608 | 460239120 | 0 | 54351121968 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 251 | 51077443296 | 203495688 | 16546851024 | 1073516928 | 660264000 | 49343662368 | 59 | 832 | 14.1017 | 4 | 420 | 105.0000 | |
sql/io_cache | 120 | 8806526784 | 73387512 | 4423795200 | 308096448 | 6630739632 | 1867690704 | 32 | 2231296 | 69728.0000 | 48 | 2196304 | 45756.3333 | |
myisam/kfile | 12 | 4374973680 | 364581096 | 2085480672 | 4326581424 | 0 | 48392256 | 6 | 1296 | 216.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 2685754368 | 335719296 | 1979447184 | 2421787632 | 0 | 263966736 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 977376048 | 65158368 | 887763360 | 0 | 0 | 977376048 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 564304224 | 112860792 | 548869728 | 550211376 | 0 | 14092848 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/data | 73 | 460744944 | 6311448 | 45416976 | 97784016 | 0 | 362960928 | 29 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 2 | 303567264 | 151783632 | 300716064 | 0 | 0 | 303567264 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 292596480 | 97532160 | 271508688 | 271508688 | 0 | 21087792 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 9 | 55506528 | 6167304 | 16510032 | 0 | 0 | 55506528 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 47992560 | 15997344 | 39897792 | 0 | 5943168 | 42049392 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|