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 | 263 | 1383727363920 | 2 | 886402176 | 162 | 99347939856 | 99 | 1283493021888 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 46 | 387702347472 | 0 | 0 | 27 | 1423831728 | 19 | 386278515744 | |
/var/lib/mysql/ibdata1 | 54 | 333790272816 | 20 | 11089104048 | 15 | 1931449872 | 19 | 320769718896 | |
/var/lib/mysql/ibtmp1 | 147 | 273841065696 | 0 | 0 | 143 | 14045077728 | 4 | 259795987968 | |
/var/lib/mysql/mysql.ibd | 368 | 146792435328 | 346 | 109962899904 | 11 | 189499200 | 11 | 36640036224 | |
/var/lib/mysql/undo_001 | 476 | 123666988896 | 387 | 47381398944 | 78 | 953893776 | 11 | 75331696176 | |
/var/lib/mysql/undo_002 | 468 | 105748495776 | 382 | 32963752800 | 75 | 1048075776 | 11 | 71736667200 | |
/var/lib/mysql/ib_logfile0 | 23 | 100324124736 | 6 | 700801728 | 7 | 1255635216 | 10 | 98367687792 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 18 | 80563477104 | 0 | 0 | 10 | 561818928 | 8 | 80001658176 | |
/var/lib/mysql/#innodb_temp/temp_1.ibt | 8 | 65581766448 | 0 | 0 | 3 | 286034496 | 5 | 65295731952 | |
/var/lib/mysql/#innodb_temp/temp_6.ibt | 8 | 37049144352 | 0 | 0 | 3 | 255994992 | 5 | 36793149360 | |
/var/lib/mysql/binlog.000008 | 6 | 36834101040 | 0 | 0 | 2 | 30217968 | 4 | 36803883072 | |
/var/lib/mysql/#innodb_temp/temp_2.ibt | 8 | 36728440320 | 0 | 0 | 3 | 258871536 | 5 | 36469568784 | |
/var/lib/mysql/#innodb_temp/temp_4.ibt | 8 | 36614132016 | 0 | 0 | 3 | 250185936 | 5 | 36363946080 | |
/var/lib/mysql/#innodb_temp/temp_3.ibt | 8 | 35879250528 | 0 | 0 | 3 | 253174944 | 5 | 35626075584 | |
/var/lib/mysql/#innodb_temp/temp_7.ibt | 8 | 34827821952 | 0 | 0 | 3 | 249605664 | 5 | 34578216288 | |
/var/lib/mysql/#innodb_temp/temp_8.ibt | 8 | 33084223920 | 0 | 0 | 3 | 247827360 | 5 | 32836396560 | |
/var/lib/mysql/#innodb_temp/temp_5.ibt | 8 | 33041528784 | 0 | 0 | 3 | 247951440 | 5 | 32793577344 | |
/var/lib/mysql/sakila/rental.ibd | 56 | 32500803456 | 51 | 32450463936 | 0 | 0 | 5 | 50339520 | |
/usr/share/mysql-8.0/french/errmsg.sys | 5 | 21075424128 | 3 | 11192974848 | 0 | 0 | 2 | 9882449280 | |
/var/lib/mysql/binlog.index | 13 | 18133142544 | 3 | 331447776 | 0 | 0 | 10 | 17801694768 | |
/var/lib/mysql/sakila/staff.ibd | 9 | 16758617568 | 4 | 3137597232 | 0 | 0 | 5 | 13621020336 | |
/var/lib/mysql/sakila/payment.ibd | 53 | 14392001184 | 48 | 14349668784 | 0 | 0 | 5 | 42332400 | |
/var/lib/mysql/vedettfak/fa.ibd | 17 | 13477146144 | 12 | 13414906560 | 0 | 0 | 5 | 62239584 | |
/var/lib/mysql/sakila/store.ibd | 9 | 7697960160 | 4 | 7638371136 | 0 | 0 | 5 | 59589024 |
|