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 | 3248 | 17908983872736 | 5513849616 | 390494404608 | 1930543296 | 621453195264 | 17285600134176 | 8 | 70656 | 8832.0000 | 2067 | 3191808 | 1544.1742 | |
innodb/innodb_data_file | 5201 | 10995929655744 | 2114195160 | 224988546816 | 339399650304 | 154351278576 | 10502178726864 | 1416 | 28311552 | 19994.0339 | 2643 | 95141888 | 35997.6875 | |
sql/binlog | 586 | 1008920241648 | 1721706888 | 49323027600 | 1004065392 | 3201293040 | 1004714883216 | 112 | 1191 | 10.6339 | 67 | 23692 | 353.6119 | |
innodb/innodb_temp_file | 114 | 538201505424 | 4721065800 | 41453083056 | 0 | 2950120800 | 535251384624 | 0 | 0 | 0.0000 | 47 | 1884160 | 40088.5106 | |
sql/binlog_index | 38 | 51802032480 | 1363211256 | 32058328368 | 378331008 | 0 | 51423701472 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 50 | 38689960320 | 773799048 | 3428419104 | 23131087584 | 0 | 15558872736 | 30 | 3073386 | 102446.2000 | 0 | 0 | 0.0000 | |
sql/io_cache | 201 | 4678915824 | 23277936 | 600916800 | 356579520 | 2032369152 | 2289967152 | 66 | 4079390 | 61808.9394 | 80 | 4040024 | 50500.3000 | |
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 |
|