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 | 4238 | 22685798675232 | 5352949008 | 192958303296 | 981823920 | 856525147104 | 21828291704208 | 8 | 70656 | 8832.0000 | 2702 | 4213248 | 1559.3072 | |
innodb/innodb_data_file | 6667 | 14031514137168 | 2104621728 | 225338121360 | 313980671664 | 183177964992 | 13534355500512 | 1441 | 28721152 | 19931.4032 | 3786 | 131973120 | 34858.1933 | |
sql/binlog | 731 | 1680739351104 | 2299233024 | 42475833312 | 852198864 | 3385126272 | 1676502025968 | 127 | 1104 | 8.6929 | 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 | 30 | 2252528784 | 75084240 | 1025559744 | 104088864 | 805694736 | 1342745184 | 8 | 557824 | 69728.0000 | 12 | 549076 | 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 |
|