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 | 832 | 4487589666912 | 5393737536 | 64113849360 | 1331873136 | 138464497248 | 4347793296528 | 8 | 70656 | 8832.0000 | 493 | 390656 | 792.4057 | |
innodb/innodb_data_file | 2441 | 2537412740544 | 1039497096 | 260930042736 | 258983893872 | 36555236784 | 2241873609888 | 1290 | 26247168 | 20346.6419 | 846 | 36519936 | 43167.7730 | |
innodb/innodb_temp_file | 106 | 436265108400 | 4115708520 | 23393258064 | 0 | 3177605904 | 433087502496 | 0 | 0 | 0.0000 | 41 | 1654784 | 40360.5854 | |
sql/binlog | 93 | 80695297584 | 867691176 | 24264501360 | 1564813536 | 597001680 | 78533482368 | 19 | 672 | 35.3684 | 5 | 591 | 118.2000 | |
sql/binlog_index | 38 | 51666919392 | 1359655704 | 32769960432 | 625521072 | 0 | 51041398320 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 32165244672 | 584822568 | 5902461312 | 15124298640 | 0 | 17040946032 | 33 | 3372655 | 102201.6667 | 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 | 3 | 252427824 | 84142608 | 225640800 | 0 | 0 | 252427824 | 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 |
|