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_data_file | 2478 | 4125899342400 | 1665011832 | 865909180752 | 1143205013280 | 41234930880 | 2941459398240 | 1380 | 27721728 | 20088.2087 | 699 | 31801344 | 45495.4850 | |
innodb/innodb_log_file | 520 | 2811805914192 | 5407319016 | 55907680224 | 1665183696 | 58293857424 | 2751846873072 | 8 | 70656 | 8832.0000 | 299 | 293376 | 981.1906 | |
innodb/innodb_temp_file | 151 | 703490570112 | 4658877696 | 23698900896 | 0 | 3589187184 | 699901382928 | 0 | 0 | 0.0000 | 72 | 3080192 | 42780.4444 | |
sql/binlog | 1166 | 116549870976 | 99957000 | 24297593760 | 2042943936 | 4579010304 | 109927916736 | 287 | 1891 | 6.5889 | 7 | 1213 | 173.2857 | |
sql/binlog_index | 38 | 55160528016 | 1451592648 | 29829081744 | 1867154256 | 0 | 53293373760 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 65 | 49014630720 | 754071120 | 9354486768 | 25022073648 | 0 | 23992557072 | 39 | 3989575 | 102296.7949 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 1664522112 | 208065264 | 1081908960 | 1305404496 | 0 | 359117616 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 942445680 | 62829624 | 875809440 | 0 | 0 | 942445680 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 728736096 | 145747008 | 703686720 | 705852048 | 0 | 22884048 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 343473504 | 114490992 | 314600352 | 0 | 0 | 343473504 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 294997824 | 98332608 | 269738304 | 269738304 | 0 | 25259520 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 69275712 | 17318928 | 38932608 | 0 | 0 | 69275712 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 55510224 | 18503232 | 36900336 | 0 | 15727536 | 39782688 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|