SELECT * FROM `x$io_global_by_file_by_latency`
|
file | total | total_latency | count_read | read_latency | count_write | write_latency | count_misc | misc_latency | |
---|---|---|---|---|---|---|---|---|---|
/var/lib/mysql/ib_logfile1 | 220 | 1315004312160 | 2 | 743833200 | 129 | 34194643296 | 89 | 1280065835664 | |
/var/lib/mysql/ibdata1 | 99 | 666734681712 | 20 | 12890432016 | 37 | 2640238128 | 42 | 651204011568 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 41 | 300181527360 | 0 | 0 | 26 | 1567582896 | 15 | 298613944464 | |
/var/lib/mysql/ib_logfile0 | 47 | 293905897824 | 6 | 542274480 | 19 | 1162048272 | 22 | 292201575072 | |
/var/lib/mysql/undo_001 | 465 | 250592430000 | 387 | 65656106208 | 57 | 2807226048 | 21 | 182129097744 | |
/var/lib/mysql/ibtmp1 | 147 | 226837661952 | 0 | 0 | 143 | 18821982432 | 4 | 208015679520 | |
/var/lib/mysql/undo_002 | 446 | 169663195680 | 382 | 29156521152 | 45 | 1852026528 | 19 | 138654648000 | |
/var/lib/mysql/mysql.ibd | 369 | 164468937072 | 318 | 73268198256 | 29 | 762877632 | 22 | 90437861184 | |
/var/lib/mysql/#innodb_temp/temp_8.ibt | 8 | 44388698112 | 0 | 0 | 3 | 232984224 | 5 | 44155713888 | |
/var/lib/mysql/#innodb_temp/temp_6.ibt | 8 | 43962518688 | 0 | 0 | 3 | 157401024 | 5 | 43805117664 | |
/var/lib/mysql/#innodb_temp/temp_1.ibt | 8 | 43123921632 | 0 | 0 | 3 | 279158880 | 5 | 42844762752 | |
/var/lib/mysql/#innodb_temp/temp_5.ibt | 8 | 37960463376 | 0 | 0 | 3 | 77398464 | 5 | 37883064912 | |
/var/lib/mysql/#innodb_temp/temp_2.ibt | 8 | 34696205280 | 0 | 0 | 3 | 217400304 | 5 | 34478804976 | |
/var/lib/mysql/binlog.000008 | 6 | 33617204016 | 0 | 0 | 2 | 75265872 | 4 | 33541938144 | |
/var/lib/mysql/#innodb_temp/temp_7.ibt | 8 | 33551926848 | 0 | 0 | 3 | 257125440 | 5 | 33294801408 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 8 | 32634507840 | 0 | 0 | 3 | 400930464 | 5 | 32233577376 | |
/var/lib/mysql/#innodb_temp/temp_4.ibt | 8 | 28091172384 | 0 | 0 | 3 | 82698000 | 5 | 28008474384 | |
/var/lib/mysql/#innodb_temp/temp_3.ibt | 8 | 27421720656 | 0 | 0 | 3 | 106507632 | 5 | 27315213024 | |
/var/lib/mysql/binlog.index | 13 | 18273580512 | 3 | 30345744 | 0 | 0 | 10 | 18243234768 | |
/var/lib/mysql/sakila/country.ibd | 9 | 7279845936 | 4 | 7227404448 | 0 | 0 | 5 | 52441488 | |
/usr/share/mysql-8.0/russian/errmsg.sys | 5 | 5454884688 | 3 | 3171408240 | 0 | 0 | 2 | 2283476448 | |
/usr/share/mysql-8.0/korean/errmsg.sys | 5 | 4873180752 | 3 | 2873955744 | 0 | 0 | 2 | 1999225008 | |
/var/lib/mysql/test19/rallye.ibd | 9 | 4373585040 | 4 | 4316498208 | 0 | 0 | 5 | 57086832 | |
/var/lib/mysql/sakila/address.ibd | 11 | 4184389440 | 6 | 4121244864 | 0 | 0 | 5 | 63144576 | |
/usr/share/mysql-8.0/portuguese/errmsg.sys | 5 | 3818969616 | 3 | 2039774880 | 0 | 0 | 2 | 1779194736 |
|