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 | 2279 | 10418180688432 | 4571382288 | 150927402384 | 1244499168 | 349972875120 | 10066963314144 | 8 | 70656 | 8832.0000 | 1493 | 2439168 | 1633.7361 | |
innodb/innodb_data_file | 4093 | 4312030428288 | 1053513384 | 212227573008 | 268382505600 | 44678850480 | 3998969072208 | 1525 | 30097408 | 19736.0052 | 1767 | 65257472 | 36931.2235 | |
innodb/innodb_temp_file | 204 | 1035873085104 | 5077809000 | 43780112112 | 0 | 3568442064 | 1032304643040 | 0 | 0 | 0.0000 | 108 | 4784128 | 44297.4815 | |
sql/binlog | 737 | 505215446736 | 685502400 | 20046995760 | 1262241024 | 1857884160 | 502095321552 | 164 | 1252 | 7.6341 | 37 | 7301 | 197.3243 | |
sql/ERRMSG | 60 | 65477251488 | 1091287296 | 24960319824 | 19545231024 | 0 | 45932020464 | 36 | 3695778 | 102660.5000 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 42042741840 | 1106387832 | 25254459648 | 432767280 | 0 | 41609974560 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/misc | 5 | 1921205616 | 384240912 | 1844778144 | 0 | 0 | 1921205616 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1508866656 | 100590864 | 1427685072 | 0 | 0 | 1508866656 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 9 | 1362976560 | 151441752 | 633151728 | 635720448 | 0 | 727256112 | 2 | 392 | 196.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 1056640464 | 132079992 | 476976192 | 885964992 | 0 | 170675472 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 30 | 640130832 | 21337536 | 57673440 | 86283648 | 308849904 | 244997280 | 8 | 557824 | 69728.0000 | 12 | 549076 | 45756.3333 | |
mysys/cnf | 5 | 573747504 | 114749448 | 554517216 | 555753264 | 0 | 17994240 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 358809792 | 119603088 | 329934528 | 329934528 | 0 | 28875264 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 7 | 228639840 | 32662608 | 171033984 | 0 | 0 | 228639840 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 22 | 125968656 | 5725632 | 28129200 | 34569744 | 0 | 91398912 | 8 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 18692256 | 6230664 | 13090176 | 0 | 4296336 | 14395920 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|