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 | 1977 | 8643375485712 | 4371965136 | 150927402384 | 1244499168 | 325218641088 | 8316912345456 | 8 | 70656 | 8832.0000 | 1319 | 2324992 | 1762.6929 | |
innodb/innodb_data_file | 3623 | 3246821023776 | 896169120 | 212227573008 | 258464540400 | 38422123872 | 2949934359504 | 1457 | 28983296 | 19892.4475 | 1479 | 56672256 | 38317.9554 | |
innodb/innodb_temp_file | 144 | 720815240112 | 5005661232 | 43780112112 | 0 | 2185368240 | 718629871872 | 0 | 0 | 0.0000 | 66 | 2916352 | 44187.1515 | |
sql/binlog | 365 | 470090397216 | 1287918720 | 20046995760 | 1012224576 | 1829660448 | 467248512192 | 72 | 884 | 12.2778 | 35 | 6785 | 193.8571 | |
sql/ERRMSG | 50 | 60557174304 | 1211143296 | 24960319824 | 17275797264 | 0 | 43281377040 | 30 | 3077203 | 102573.4333 | 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 | |
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 | |
csv/metadata | 4 | 504854592 | 126213648 | 408988800 | 408988800 | 0 | 95865792 | 1 | 35 | 35.0000 | 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 | 9 | 51525408 | 5724840 | 17335824 | 14553264 | 0 | 36972144 | 3 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 18692256 | 6230664 | 13090176 | 0 | 4296336 | 14395920 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|