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 | 228 | 1362933680592 | 2 | 743833200 | 134 | 34256678016 | 92 | 1327933169376 | |
/var/lib/mysql/ibdata1 | 107 | 716085971040 | 20 | 12890432016 | 41 | 2726523360 | 46 | 700469015664 | |
/var/lib/mysql/ib_logfile0 | 51 | 322339865760 | 6 | 542274480 | 21 | 1216594368 | 24 | 320580996912 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 41 | 300181527360 | 0 | 0 | 26 | 1567582896 | 15 | 298613944464 | |
/var/lib/mysql/undo_001 | 468 | 259282352208 | 387 | 65656106208 | 59 | 2851588608 | 22 | 190774657392 | |
/var/lib/mysql/ibtmp1 | 147 | 226837661952 | 0 | 0 | 143 | 18821982432 | 4 | 208015679520 | |
/var/lib/mysql/undo_002 | 449 | 180014724384 | 382 | 29156521152 | 47 | 1874700432 | 20 | 148983502800 | |
/var/lib/mysql/mysql.ibd | 372 | 168420001728 | 318 | 73268198256 | 31 | 791924496 | 23 | 94359878976 | |
/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/StdMdDB/student.ibd | 9 | 13117960944 | 4 | 6812040048 | 0 | 0 | 5 | 6305920896 | |
/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 |
|