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 | 1848 | 9956004037584 | 5387448000 | 64113849360 | 1331873136 | 258352357824 | 9696319806624 | 8 | 70656 | 8832.0000 | 1107 | 883712 | 798.2945 | |
innodb/innodb_data_file | 3941 | 5316987426432 | 1349146656 | 260930042736 | 264593020032 | 84361581744 | 4968032824656 | 1304 | 26476544 | 20304.0982 | 2113 | 76267520 | 36094.4250 | |
innodb/innodb_temp_file | 126 | 598216865136 | 4747752768 | 41151824208 | 0 | 3787711488 | 594429153648 | 0 | 0 | 0.0000 | 54 | 2326528 | 43083.8519 | |
sql/binlog | 203 | 154453338336 | 760853808 | 24264501360 | 1640933184 | 695871792 | 152116533360 | 44 | 772 | 17.5455 | 10 | 1919 | 191.9000 | |
sql/binlog_index | 38 | 51666919392 | 1359655704 | 32769960432 | 625521072 | 0 | 51041398320 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 65 | 37636970976 | 579030144 | 5902461312 | 18240898368 | 0 | 19396072608 | 39 | 3988885 | 102279.1026 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 3593651952 | 449206296 | 1890788064 | 591483024 | 0 | 3002168928 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1362985536 | 272596896 | 1344145968 | 1345327632 | 0 | 17657904 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 766368240 | 51091128 | 704028336 | 0 | 0 | 766368240 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 46 | 668803872 | 14539008 | 417266256 | 478058064 | 0 | 190745808 | 18 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 344316192 | 114771888 | 330950928 | 330950928 | 0 | 13365264 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 6 | 313698528 | 52283088 | 225640800 | 0 | 0 | 313698528 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 46878480 | 15626160 | 36913536 | 0 | 7265280 | 39613200 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|