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 | 717 | 4021356850896 | 5608586808 | 78012722304 | 1549593408 | 81833535168 | 3937973722320 | 8 | 70656 | 8832.0000 | 404 | 312320 | 773.0693 | |
innodb/innodb_data_file | 2860 | 3348132719184 | 1170675528 | 224106891360 | 433977199392 | 32111340624 | 2882044179168 | 1507 | 29802496 | 19776.0425 | 868 | 36487168 | 42035.9078 | |
innodb/innodb_temp_file | 251 | 1082297143488 | 4311940776 | 244922771808 | 0 | 6463193616 | 1075833949872 | 0 | 0 | 0.0000 | 166 | 5013504 | 30201.8313 | |
sql/binlog_index | 38 | 52193350704 | 1373509104 | 29803907232 | 1953063552 | 0 | 50240287152 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 250 | 41358814464 | 165435072 | 19879914912 | 1088051184 | 56487024 | 40214276256 | 60 | 983 | 16.3833 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 45 | 20520570048 | 456012480 | 4150765344 | 11631399120 | 0 | 8889170928 | 27 | 2765852 | 102438.9630 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 5561160528 | 695145000 | 1910392176 | 3225016608 | 0 | 2336143920 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
csv/data | 58 | 2098226064 | 36176184 | 1108885536 | 1184633472 | 0 | 913592592 | 24 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 30 | 1825808688 | 60860184 | 692500512 | 116042256 | 715560912 | 994205520 | 8 | 557824 | 69728.0000 | 12 | 549076 | 45756.3333 | |
myisam/kfile | 12 | 1601955696 | 133496088 | 628959408 | 1534936128 | 0 | 67019568 | 6 | 1311 | 218.5000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 739322496 | 147864288 | 707769216 | 709581312 | 0 | 29741184 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 725824176 | 48388032 | 666037680 | 0 | 0 | 725824176 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 64 | 571375728 | 8927688 | 418450560 | 440403216 | 0 | 130972512 | 50 | 1950 | 39.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 318050832 | 106016856 | 303293760 | 303293760 | 0 | 14757072 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 61467648 | 20489040 | 40432128 | 0 | 17435616 | 44032032 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 13423872 | 13423872 | 13423872 | 0 | 0 | 13423872 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|