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 | 187 | 899347373760 | 2 | 751693008 | 111 | 17478754656 | 74 | 881116926096 | |
/var/lib/mysql/ibdata1 | 98 | 499627633296 | 22 | 5882324448 | 36 | 3588050400 | 40 | 490157258448 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 135 | 235393313760 | 0 | 0 | 117 | 1986924192 | 18 | 233406389568 | |
/var/lib/mysql/ib_logfile0 | 43 | 228172141824 | 6 | 738347280 | 17 | 2176303008 | 20 | 225257491536 | |
/var/lib/mysql/mysql.ibd | 455 | 175357556880 | 377 | 97995616752 | 58 | 733590000 | 20 | 76628350128 | |
/var/lib/mysql/undo_001 | 437 | 101205057888 | 386 | 31223337024 | 34 | 994510176 | 17 | 68987210688 | |
/var/lib/mysql/undo_002 | 433 | 84809190048 | 389 | 29652098256 | 27 | 1116826128 | 17 | 54040265664 | |
/var/lib/mysql/ibtmp1 | 147 | 80650504704 | 0 | 0 | 143 | 6608565216 | 4 | 74041939488 | |
/var/lib/mysql/clientes/2.ibd | 13 | 69154753008 | 0 | 0 | 7 | 99833184 | 6 | 69054919824 | |
/var/lib/mysql/binlog.000010 | 10 | 64831189104 | 0 | 0 | 4 | 907541184 | 6 | 63923647920 | |
/var/lib/mysql/#innodb_temp/temp_1.ibt | 8 | 42647115456 | 0 | 0 | 3 | 274029888 | 5 | 42373085568 | |
/var/lib/mysql/#innodb_temp/temp_2.ibt | 8 | 36161011392 | 0 | 0 | 3 | 199115136 | 5 | 35961896256 | |
/var/lib/mysql/#innodb_temp/temp_8.ibt | 8 | 31233388032 | 0 | 0 | 3 | 95618688 | 5 | 31137769344 | |
/var/lib/mysql/#innodb_temp/temp_7.ibt | 8 | 28082026896 | 0 | 0 | 3 | 132823680 | 5 | 27949203216 | |
/var/lib/mysql/#innodb_temp/temp_4.ibt | 8 | 27060015312 | 0 | 0 | 3 | 132356400 | 5 | 26927658912 | |
/var/lib/mysql/#innodb_temp/temp_6.ibt | 8 | 26702482224 | 0 | 0 | 3 | 178280784 | 5 | 26524201440 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 8 | 26693868960 | 0 | 0 | 3 | 138241488 | 5 | 26555627472 | |
/var/lib/mysql/#innodb_temp/temp_5.ibt | 8 | 25704484080 | 0 | 0 | 3 | 176505648 | 5 | 25527978432 | |
/var/lib/mysql/#innodb_temp/temp_3.ibt | 8 | 25572189984 | 0 | 0 | 3 | 97306704 | 5 | 25474883280 | |
/var/lib/mysql/sakila/rental.ibd | 56 | 6405803184 | 51 | 5185824336 | 0 | 0 | 5 | 1219978848 | |
/var/lib/mysql/sakila/payment.ibd | 53 | 6327691920 | 48 | 6270805200 | 0 | 0 | 5 | 56886720 | |
/var/lib/mysql/sakila/inventory.ibd | 21 | 5429224416 | 16 | 3283944048 | 0 | 0 | 5 | 2145280368 | |
/usr/share/mysql-8.0/spanish/errmsg.sys | 5 | 4794867264 | 3 | 874107696 | 0 | 0 | 2 | 3920759568 | |
/var/lib/mysql/sakila/category.ibd | 9 | 4154976672 | 4 | 2141934432 | 0 | 0 | 5 | 2013042240 | |
/var/lib/mysql/QCMed/Answer.ibd | 9 | 3899541360 | 4 | 3852092112 | 0 | 0 | 5 | 47449248 |
|