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 | 377 | 2151550191120 | 5707029504 | 201454558800 | 1154617728 | 125247095424 | 2025148477968 | 8 | 70656 | 8832.0000 | 220 | 202240 | 919.2727 | |
innodb/innodb_data_file | 1912 | 1662374412864 | 869442552 | 346652508576 | 285044746272 | 22547318112 | 1354782348480 | 1287 | 26198016 | 20355.8788 | 413 | 23085056 | 55896.0194 | |
innodb/innodb_temp_file | 90 | 345101584608 | 3834461928 | 22059316224 | 0 | 2353209936 | 342748374672 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | |
sql/binlog | 81 | 66295059600 | 818457288 | 16898311584 | 2769015744 | 1183405344 | 62342638512 | 16 | 660 | 41.2500 | 5 | 658 | 131.6000 | |
sql/binlog_index | 38 | 49641094272 | 1306344336 | 24859583760 | 993511728 | 0 | 48647582544 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 25 | 20589958752 | 823598160 | 4086680928 | 9811520928 | 0 | 10778437824 | 15 | 1543523 | 102901.5333 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 795453648 | 99431640 | 391095408 | 606514128 | 0 | 188939520 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 742025856 | 49468320 | 673318272 | 0 | 0 | 742025856 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 611078160 | 203692632 | 531278880 | 0 | 0 | 611078160 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 567025008 | 113404896 | 522323472 | 548113104 | 0 | 18911904 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 329010528 | 109670088 | 314775120 | 314775120 | 0 | 14235408 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 47374272 | 15791424 | 37344384 | 0 | 7372464 | 40001808 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
csv/data | 4 | 32090784 | 8022696 | 10191456 | 0 | 0 | 32090784 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|