SELECT * FROM `x$io_global_by_file_by_bytes`
|
file | count_read | total_read | avg_read | count_write | total_written | avg_write | total | write_pct | |
---|---|---|---|---|---|---|---|---|---|
/var/lib/mysql/ibtmp1 | 0 | 0 | 0.0000 | 143 | 14729216 | 103001.5105 | 14729216 | 100.00 | |
/var/lib/mysql/undo_001 | 388 | 6406144 | 16510.6804 | 237 | 3883008 | 16384.0000 | 10289152 | 37.74 | |
/var/lib/mysql/ibdata1 | 20 | 2441216 | 122060.8000 | 38 | 7831552 | 206093.4737 | 10272768 | 76.24 | |
/var/lib/mysql/undo_002 | 382 | 6307840 | 16512.6702 | 143 | 2342912 | 16384.0000 | 8650752 | 27.08 | |
/var/lib/mysql/mysql.ibd | 405 | 6684672 | 16505.3630 | 61 | 999424 | 16384.0000 | 7684096 | 13.01 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 0 | 0 | 0.0000 | 195 | 3653632 | 18736.5744 | 3653632 | 100.00 | |
/usr/share/mysql-8.0/russian/errmsg.sys | 3 | 318782 | 106260.6667 | 0 | 0 | 0.0000 | 318782 | 0.00 | |
/var/lib/mysql/ib_logfile1 | 2 | 66048 | 33024.0000 | 263 | 248320 | 944.1825 | 314368 | 78.99 | |
/usr/share/mysql-8.0/japanese/errmsg.sys | 3 | 310953 | 103651.0000 | 0 | 0 | 0.0000 | 310953 | 0.00 | |
/usr/share/mysql-8.0/spanish/errmsg.sys | 3 | 305161 | 101720.3333 | 0 | 0 | 0.0000 | 305161 | 0.00 | |
/usr/share/mysql-8.0/french/errmsg.sys | 3 | 304914 | 101638.0000 | 0 | 0 | 0.0000 | 304914 | 0.00 | |
/usr/share/mysql-8.0/slovak/errmsg.sys | 3 | 304033 | 101344.3333 | 0 | 0 | 0.0000 | 304033 | 0.00 | |
/usr/share/mysql-8.0/english/errmsg.sys | 3 | 303507 | 101169.0000 | 0 | 0 | 0.0000 | 303507 | 0.00 | |
/var/lib/mysql/buknoy/students.ibd | 0 | 0 | 0.0000 | 7 | 212992 | 30427.4286 | 212992 | 100.00 | |
/var/lib/mysql/sakila/customer.ibd | 9 | 196608 | 21845.3333 | 0 | 0 | 0.0000 | 196608 | 0.00 | |
/var/lib/mysql/sakila/address.ibd | 5 | 131072 | 26214.4000 | 0 | 0 | 0.0000 | 131072 | 0.00 | |
/var/lib/mysql/sakila/inventory.ibd | 5 | 131072 | 26214.4000 | 0 | 0 | 0.0000 | 131072 | 0.00 | |
/var/lib/mysql/#innodb_temp/temp_7.ibt | 0 | 0 | 0.0000 | 3 | 114688 | 38229.3333 | 114688 | 100.00 | |
/var/lib/mysql/#innodb_temp/temp_6.ibt | 0 | 0 | 0.0000 | 3 | 114688 | 38229.3333 | 114688 | 100.00 | |
/var/lib/mysql/#innodb_temp/temp_5.ibt | 0 | 0 | 0.0000 | 3 | 114688 | 38229.3333 | 114688 | 100.00 | |
/var/lib/mysql/sakila/store.ibd | 4 | 114688 | 28672.0000 | 0 | 0 | 0.0000 | 114688 | 0.00 | |
/var/lib/mysql/#innodb_temp/temp_4.ibt | 0 | 0 | 0.0000 | 3 | 114688 | 38229.3333 | 114688 | 100.00 | |
/var/lib/mysql/sakila/category.ibd | 4 | 114688 | 28672.0000 | 0 | 0 | 0.0000 | 114688 | 0.00 | |
/var/lib/mysql/Table_insertion/RK.ibd | 4 | 114688 | 28672.0000 | 0 | 0 | 0.0000 | 114688 | 0.00 | |
/var/lib/mysql/#innodb_temp/temp_2.ibt | 0 | 0 | 0.0000 | 3 | 114688 | 38229.3333 | 114688 | 100.00 |
|