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 | 387 | 6389760 | 16511.0078 | 60 | 983040 | 16384.0000 | 7372800 | 13.33 | |
/var/lib/mysql/undo_002 | 382 | 6307840 | 16512.6702 | 44 | 720896 | 16384.0000 | 7028736 | 10.26 | |
/var/lib/mysql/ibdata1 | 20 | 2441216 | 122060.8000 | 36 | 3948544 | 109681.7778 | 6389760 | 61.79 | |
/var/lib/mysql/mysql.ibd | 311 | 5144576 | 16542.0450 | 14 | 229376 | 16384.0000 | 5373952 | 4.27 | |
/var/lib/mysql/sakila/film_actor.ibd | 22 | 409600 | 18618.1818 | 77 | 1261568 | 16384.0000 | 1671168 | 75.49 | |
/var/lib/mysql/sakila/rental.ibd | 51 | 884736 | 17347.7647 | 0 | 0 | 0.0000 | 884736 | 0.00 | |
/var/lib/mysql/sakila/payment.ibd | 48 | 835584 | 17408.0000 | 0 | 0 | 0.0000 | 835584 | 0.00 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 0 | 0 | 0.0000 | 30 | 819200 | 27306.6667 | 819200 | 100.00 | |
/var/lib/mysql/ib_logfile1 | 2 | 66048 | 33024.0000 | 141 | 309760 | 2196.8794 | 375808 | 82.43 | |
/var/lib/mysql/sakila/actor.ibd | 5 | 131072 | 26214.4000 | 14 | 229376 | 16384.0000 | 360448 | 63.64 | |
/usr/share/mysql-8.0/russian/errmsg.sys | 3 | 318782 | 106260.6667 | 0 | 0 | 0.0000 | 318782 | 0.00 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 0 | 0 | 0.0000 | 7 | 311296 | 44470.8571 | 311296 | 100.00 | |
/var/lib/mysql/sakila/film.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/romanian/errmsg.sys | 3 | 305219 | 101739.6667 | 0 | 0 | 0.0000 | 305219 | 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/swedish/errmsg.sys | 3 | 304360 | 101453.3333 | 0 | 0 | 0.0000 | 304360 | 0.00 | |
/usr/share/mysql-8.0/czech/errmsg.sys | 3 | 304266 | 101422.0000 | 0 | 0 | 0.0000 | 304266 | 0.00 | |
/usr/share/mysql-8.0/english/errmsg.sys | 3 | 303507 | 101169.0000 | 0 | 0 | 0.0000 | 303507 | 0.00 | |
/var/lib/mysql/sakila/inventory.ibd | 14 | 278528 | 19894.8571 | 0 | 0 | 0.0000 | 278528 | 0.00 | |
/var/lib/mysql/sakila/address.ibd | 8 | 180224 | 22528.0000 | 0 | 0 | 0.0000 | 180224 | 0.00 |
|