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 | 3568 | 19574111093856 | 5486017680 | 107173599456 | 1177684992 | 538791183744 | 19034142225120 | 8 | 70656 | 8832.0000 | 2216 | 2873856 | 1296.8664 | |
innodb/innodb_data_file | 6576 | 13220981718912 | 2010489888 | 232773667632 | 251422257504 | 179597188848 | 12789962272560 | 1549 | 30490624 | 19684.0697 | 3666 | 126107648 | 34399.2493 | |
innodb/innodb_temp_file | 661 | 1449999403248 | 2193644904 | 176545611792 | 0 | 229554200304 | 1220445202944 | 0 | 0 | 0.0000 | 552 | 12910592 | 23388.7536 | |
sql/binlog | 659 | 1248300528816 | 1894234320 | 33258571104 | 4724938944 | 6593678784 | 1236981911088 | 120 | 1076 | 8.9667 | 86 | 31572 | 367.1163 | |
sql/binlog_index | 38 | 51532765680 | 1356125232 | 34473055056 | 1782996864 | 0 | 49749768816 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 70 | 35935622448 | 513365952 | 3240814896 | 21581579184 | 0 | 14354043264 | 42 | 4303782 | 102471.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 616 | 22196997504 | 36033888 | 9171085440 | 2499345552 | 6313723680 | 13383928272 | 308 | 14978368 | 48631.0649 | 248 | 14978368 | 60396.6452 | |
myisam/kfile | 63 | 3272636928 | 51946488 | 1674848208 | 1949341152 | 102627888 | 1220667888 | 10 | 2094 | 209.4000 | 34 | 1555 | 45.7353 | |
csv/metadata | 8 | 2134113168 | 266764080 | 1088562816 | 1553068704 | 0 | 581044464 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 848983872 | 56598696 | 786492432 | 0 | 0 | 848983872 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 743253456 | 148650480 | 719409504 | 721411680 | 0 | 21841776 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/SDI | 9 | 514833792 | 57203520 | 391830912 | 0 | 40861920 | 473971872 | 0 | 0 | 0.0000 | 3 | 13953 | 4651.0000 | |
csv/data | 7 | 491201040 | 70171464 | 351799536 | 351799536 | 0 | 139401504 | 1 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 19 | 360637728 | 18980808 | 35631024 | 0 | 0 | 360637728 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 295823616 | 98607696 | 275089584 | 275089584 | 0 | 20734032 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 41 | 157581072 | 3843312 | 24249984 | 0 | 78067968 | 79513104 | 0 | 0 | 0.0000 | 25 | 1016 | 40.6400 | |
sql/pid | 3 | 12876864 | 4292112 | 10220496 | 0 | 1995312 | 10881552 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|