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 | 2205 | 9903248073312 | 4491268848 | 150927402384 | 1244499168 | 341352162624 | 9560651411520 | 8 | 70656 | 8832.0000 | 1452 | 2410496 | 1660.1212 | |
innodb/innodb_data_file | 3952 | 3929886920256 | 994404576 | 212227573008 | 262425269040 | 43522182528 | 3623939468688 | 1472 | 29229056 | 19856.6957 | 1716 | 63881216 | 37226.8159 | |
innodb/innodb_temp_file | 192 | 949042458672 | 4942929288 | 43780112112 | 0 | 3230113920 | 945812344752 | 0 | 0 | 0.0000 | 100 | 4390912 | 43909.1200 | |
sql/binlog | 513 | 470822497200 | 917782536 | 20046995760 | 1111823328 | 1829660448 | 467881013424 | 109 | 1032 | 9.4679 | 35 | 6785 | 193.8571 | |
sql/ERRMSG | 55 | 64453234032 | 1171876728 | 24960319824 | 18760234416 | 0 | 45692999616 | 33 | 3382422 | 102497.6364 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 42042741840 | 1106387832 | 25254459648 | 432767280 | 0 | 41609974560 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 1884524928 | 628174800 | 1844778144 | 0 | 0 | 1884524928 | 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 |
|