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 | 3297 | 18238098246192 | 5531725056 | 390494404608 | 1930543296 | 621998084928 | 17614169617968 | 8 | 70656 | 8832.0000 | 2095 | 3208192 | 1531.3566 | |
innodb/innodb_data_file | 5352 | 11255482084176 | 2103042216 | 224988546816 | 344009617776 | 158960033760 | 10752512432640 | 1417 | 28327936 | 19991.4862 | 2770 | 99106816 | 35778.6339 | |
sql/binlog | 622 | 1009092322656 | 1622334912 | 49323027600 | 1026992736 | 3201293040 | 1004864036880 | 121 | 1227 | 10.1405 | 67 | 23692 | 353.6119 | |
innodb/innodb_temp_file | 117 | 552804677568 | 4724826216 | 41453083056 | 0 | 3073891392 | 549730786176 | 0 | 0 | 0.0000 | 49 | 1982464 | 40458.4490 | |
sql/binlog_index | 38 | 51802032480 | 1363211256 | 32058328368 | 378331008 | 0 | 51423701472 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 41787610656 | 759774576 | 3428419104 | 24011885568 | 0 | 17775725088 | 33 | 3379853 | 102419.7879 | 0 | 0 | 0.0000 | |
sql/io_cache | 216 | 4900817328 | 22688952 | 600916800 | 377111856 | 2146682736 | 2377022736 | 70 | 4358302 | 62261.4571 | 86 | 4314562 | 50169.3256 | |
mysys/cnf | 5 | 3292047264 | 658409400 | 3275252112 | 3276422160 | 0 | 15625104 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 2958093600 | 369761568 | 1569037536 | 1229999760 | 0 | 1728093840 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 2115607296 | 528901824 | 2084164896 | 0 | 0 | 2115607296 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 879414624 | 58627536 | 812650080 | 0 | 0 | 879414624 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 280023744 | 93341160 | 261075936 | 261075936 | 0 | 18947808 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 46465584 | 15488352 | 36759888 | 0 | 7066752 | 39398832 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
csv/data | 4 | 36878160 | 9219408 | 15102384 | 0 | 0 | 36878160 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|