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 | 409 | 2399529966768 | 5866821312 | 209992142448 | 1672430496 | 66214682688 | 2331642853584 | 8 | 70656 | 8832.0000 | 237 | 209920 | 885.7384 | |
innodb/innodb_data_file | 2084 | 1529961510528 | 734146512 | 252100929696 | 229467930912 | 26631162096 | 1273862417520 | 1297 | 26361856 | 20325.2552 | 552 | 27508736 | 49834.6667 | |
innodb/innodb_temp_file | 410 | 812982615984 | 1982884200 | 159932383248 | 0 | 175200264096 | 637782351888 | 0 | 0 | 0.0000 | 341 | 6832128 | 20035.5660 | |
sql/binlog_index | 38 | 66169256736 | 1741296216 | 47185489824 | 496160016 | 0 | 65673096720 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 125 | 40706160528 | 325649280 | 18954842016 | 3274517136 | 42171360 | 37389472032 | 28 | 708 | 25.2857 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 25 | 10984931232 | 439397112 | 1586807376 | 7973074560 | 0 | 3011856672 | 15 | 1536800 | 102453.3333 | 0 | 0 | 0.0000 | |
sql/io_cache | 282 | 10784290176 | 38241984 | 1535841120 | 858404448 | 5615392992 | 4310492736 | 116 | 6579060 | 56716.0345 | 116 | 6579060 | 56716.0345 | |
csv/metadata | 8 | 3482978400 | 435372168 | 1768639488 | 1474089408 | 0 | 2008888992 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 739703712 | 49313352 | 672273888 | 0 | 0 | 739703712 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 564216048 | 141053880 | 545425584 | 547092480 | 0 | 17123568 | 2 | 392 | 196.0000 | 0 | 0 | 0.0000 | |
csv/data | 8 | 492805632 | 61600704 | 425733792 | 14917056 | 0 | 477888576 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 432002208 | 86400336 | 417426240 | 418322256 | 0 | 13679952 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 252555072 | 84184848 | 239518752 | 239518752 | 0 | 13036320 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 65652576 | 21884016 | 36223968 | 0 | 25412640 | 40239936 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 13091760 | 13091760 | 13091760 | 0 | 0 | 13091760 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 2 | 9084240 | 4542120 | 8739984 | 0 | 0 | 9084240 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|