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/ibdata1 | 19 | 2424832 | 127622.7368 | 89 | 11550720 | 129783.3708 | 13975552 | 82.65 | |
/var/lib/mysql/undo_001 | 386 | 6373376 | 16511.3368 | 267 | 4374528 | 16384.0000 | 10747904 | 40.70 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 0 | 0 | 0.0000 | 568 | 10420224 | 18345.4648 | 10420224 | 100.00 | |
/var/lib/mysql/mysql.ibd | 429 | 7077888 | 16498.5734 | 154 | 2523136 | 16384.0000 | 9601024 | 26.28 | |
/var/lib/mysql/undo_002 | 387 | 6389760 | 16511.0078 | 180 | 2949120 | 16384.0000 | 9338880 | 31.58 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 0 | 0 | 0.0000 | 329 | 6897664 | 20965.5441 | 6897664 | 100.00 | |
/var/lib/mysql/ib_logfile1 | 2 | 66048 | 33024.0000 | 397 | 428032 | 1078.1662 | 494080 | 86.63 | |
/usr/share/mysql-8.0/russian/errmsg.sys | 3 | 318782 | 106260.6667 | 0 | 0 | 0.0000 | 318782 | 0.00 | |
/var/lib/mysql/sakila/inventory.ibd | 16 | 311296 | 19456.0000 | 0 | 0 | 0.0000 | 311296 | 0.00 | |
/usr/share/mysql-8.0/german/errmsg.sys | 3 | 311159 | 103719.6667 | 0 | 0 | 0.0000 | 311159 | 0.00 | |
/usr/share/mysql-8.0/japanese/errmsg.sys | 3 | 310953 | 103651.0000 | 0 | 0 | 0.0000 | 310953 | 0.00 | |
/usr/share/mysql-8.0/portuguese/errmsg.sys | 3 | 306467 | 102155.6667 | 0 | 0 | 0.0000 | 306467 | 0.00 | |
/usr/share/mysql-8.0/serbian/errmsg.sys | 3 | 305888 | 101962.6667 | 0 | 0 | 0.0000 | 305888 | 0.00 | |
/usr/share/mysql-8.0/dutch/errmsg.sys | 3 | 305286 | 101762.0000 | 0 | 0 | 0.0000 | 305286 | 0.00 | |
/usr/share/mysql-8.0/italian/errmsg.sys | 3 | 305277 | 101759.0000 | 0 | 0 | 0.0000 | 305277 | 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/polish/errmsg.sys | 3 | 304436 | 101478.6667 | 0 | 0 | 0.0000 | 304436 | 0.00 | |
/usr/share/mysql-8.0/danish/errmsg.sys | 3 | 304266 | 101422.0000 | 0 | 0 | 0.0000 | 304266 | 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/nazmul/Employees.ibd | 0 | 0 | 0.0000 | 8 | 229376 | 28672.0000 | 229376 | 100.00 | |
/var/lib/mysql/revista/usuarios.ibd | 0 | 0 | 0.0000 | 7 | 212992 | 30427.4286 | 212992 | 100.00 | |
/var/lib/mysql/SCHOOL/EMPLOYEE.ibd | 6 | 147456 | 24576.0000 | 4 | 65536 | 16384.0000 | 212992 | 30.77 |
|