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 | 4077 | 21718554382800 | 5327092056 | 192958303296 | 981823920 | 824856049776 | 20892716509104 | 8 | 70656 | 8832.0000 | 2606 | 4105728 | 1575.4904 | |
innodb/innodb_data_file | 6444 | 13442095832352 | 2085986232 | 225338121360 | 313980671664 | 179968180128 | 12948146980560 | 1441 | 28721152 | 19931.4032 | 3625 | 127057920 | 35050.4607 | |
sql/binlog | 685 | 1603810107504 | 2341328616 | 42475833312 | 813703968 | 3267778800 | 1599728624736 | 118 | 1068 | 9.0508 | 103 | 33012 | 320.5049 | |
innodb/innodb_temp_file | 125 | 631835202240 | 5054681544 | 67591920000 | 0 | 3534371808 | 628300830432 | 0 | 0 | 0.0000 | 52 | 2359296 | 45371.0769 | |
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 | 9 | 155208240 | 17245272 | 38439456 | 0 | 0 | 155208240 | 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 |
|