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 | 4251 | 22762492522704 | 5354620656 | 192958303296 | 981823920 | 856602154848 | 21904908543936 | 8 | 70656 | 8832.0000 | 2709 | 4216832 | 1556.6010 | |
innodb/innodb_data_file | 6685 | 14113507185360 | 2111220144 | 225338121360 | 313980671664 | 183331412352 | 13616195101344 | 1441 | 28721152 | 19931.4032 | 3796 | 132235264 | 34835.4226 | |
sql/binlog | 755 | 1680886407024 | 2226339456 | 42475833312 | 883161312 | 3385126272 | 1676618119440 | 133 | 1128 | 8.4812 | 108 | 34403 | 318.5463 | |
innodb/innodb_temp_file | 128 | 644671841088 | 5036498544 | 67591920000 | 0 | 3597425040 | 641074416048 | 0 | 0 | 0.0000 | 54 | 2457600 | 45511.1111 | |
sql/ERRMSG | 60 | 58842495888 | 980708256 | 13525353072 | 26113276464 | 0 | 32729219424 | 36 | 3672054 | 102001.5000 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 42252320352 | 1111903056 | 22438647264 | 292516752 | 0 | 41959803600 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 60 | 2707599840 | 45126576 | 1025559744 | 147200064 | 1035529968 | 1524869808 | 16 | 1115648 | 69728.0000 | 24 | 1098152 | 45756.3333 | |
csv/metadata | 8 | 1331884224 | 166485528 | 581799504 | 1060754640 | 0 | 271129584 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 800742624 | 160148472 | 783989184 | 785266944 | 0 | 15475680 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 755088048 | 50338992 | 682369248 | 0 | 0 | 755088048 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 616528176 | 154131912 | 336347616 | 0 | 0 | 616528176 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 260045280 | 86681760 | 247510032 | 247510032 | 0 | 12535248 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 11 | 197188992 | 17926128 | 38439456 | 0 | 0 | 197188992 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 33473088 | 11157696 | 20037600 | 0 | 11554224 | 21918864 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|