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 | 4149649037952 | 6354745584 | 974415374064 | 1736898240 | 54046702512 | 4093865437200 | 8 | 70656 | 8832.0000 | 385 | 331776 | 861.7558 | |
innodb/innodb_data_file | 2495 | 2451648187824 | 982624368 | 258297297456 | 262214647728 | 45233494944 | 2144200045152 | 1237 | 25378816 | 20516.4236 | 958 | 40222720 | 41986.1378 | |
innodb/innodb_temp_file | 307 | 800064150864 | 2606072040 | 78052379856 | 0 | 68692506960 | 731371643904 | 0 | 0 | 0.0000 | 233 | 5390336 | 23134.4893 | |
sql/binlog_index | 38 | 59304219216 | 1560637320 | 36945909792 | 795048672 | 0 | 58509170544 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 283 | 52251716880 | 184635000 | 17576517024 | 1352204304 | 260898000 | 50638614576 | 67 | 864 | 12.8955 | 4 | 420 | 105.0000 | |
sql/ERRMSG | 55 | 28846676496 | 524484840 | 3021890784 | 17214407760 | 0 | 11632268736 | 33 | 3382346 | 102495.3333 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 986604432 | 65773488 | 922901232 | 0 | 0 | 986604432 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 733137504 | 146627448 | 699411504 | 702467568 | 0 | 30669936 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 316897680 | 105632472 | 302922576 | 302922576 | 0 | 13975104 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 57048288 | 19015920 | 43457040 | 0 | 10101168 | 46947120 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 2 | 26403168 | 13201584 | 15630384 | 0 | 0 | 26403168 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|