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 | 1061 | 6316496800416 | 5953342824 | 974415374064 | 1736898240 | 95465115504 | 6219294786672 | 8 | 70656 | 8832.0000 | 629 | 502784 | 799.3386 | |
innodb/innodb_data_file | 3323 | 3634178100960 | 1093643496 | 258297297456 | 302507910672 | 55202530416 | 3276467659872 | 1470 | 29196288 | 19861.4204 | 1411 | 54214656 | 38422.8604 | |
innodb/innodb_temp_file | 328 | 934188566256 | 2848135752 | 78052379856 | 0 | 69300034320 | 864888531936 | 0 | 0 | 0.0000 | 247 | 6078464 | 24609.1660 | |
sql/binlog | 385 | 66657975120 | 173137536 | 17576517024 | 1434206928 | 1018056864 | 64205711328 | 92 | 964 | 10.4783 | 5 | 664 | 132.8000 | |
sql/binlog_index | 38 | 59304219216 | 1560637320 | 36945909792 | 795048672 | 0 | 58509170544 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 28846676496 | 524484840 | 3021890784 | 17214407760 | 0 | 11632268736 | 33 | 3382346 | 102495.3333 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 986604432 | 65773488 | 922901232 | 0 | 0 | 986604432 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 733137504 | 146627448 | 699411504 | 702467568 | 0 | 30669936 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 316897680 | 105632472 | 302922576 | 302922576 | 0 | 13975104 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 260873712 | 65218296 | 239375136 | 241392624 | 0 | 19481088 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 57048288 | 19015920 | 43457040 | 0 | 10101168 | 46947120 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 3 | 36154800 | 12051600 | 15630384 | 0 | 0 | 36154800 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 2 | 8484432 | 4242216 | 8063088 | 0 | 0 | 8484432 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|