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/ibdata1 | 20 | 2441216 | 122060.8000 | 356 | 54050816 | 151828.1348 | 56492032 | 95.68 | |
/var/lib/mysql/mysql.ibd | 441 | 7274496 | 16495.4558 | 992 | 16252928 | 16384.0000 | 23527424 | 69.08 | |
/var/lib/mysql/undo_001 | 389 | 6422528 | 16510.3548 | 993 | 16269312 | 16384.0000 | 22691840 | 71.70 | |
/var/lib/mysql/undo_002 | 386 | 6373376 | 16511.3368 | 844 | 13828096 | 16384.0000 | 20201472 | 68.45 | |
/var/lib/mysql/ibtmp1 | 0 | 0 | 0.0000 | 143 | 14729216 | 103001.5105 | 14729216 | 100.00 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 0 | 0 | 0.0000 | 371 | 9355264 | 25216.3450 | 9355264 | 100.00 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 0 | 0 | 0.0000 | 287 | 5292032 | 18439.1359 | 5292032 | 100.00 | |
/var/lib/mysql/ib_logfile1 | 2 | 66048 | 33024.0000 | 2203 | 3001856 | 1362.6219 | 3067904 | 97.85 | |
/var/lib/mysql/sakila/rental.ibd | 70 | 1196032 | 17086.1714 | 0 | 0 | 0.0000 | 1196032 | 0.00 | |
/var/lib/mysql/sakila/payment.ibd | 67 | 1146880 | 17117.6119 | 0 | 0 | 0.0000 | 1146880 | 0.00 | |
/var/lib/mysql/binlog.000008 | 0 | 0 | 0.0000 | 151 | 518515 | 3433.8742 | 518515 | 100.00 | |
/var/lib/mysql/db_php5397/web.MYD | 460 | 51320 | 111.5652 | 1956 | 341076 | 174.3742 | 392396 | 86.92 | |
/var/lib/mysql/sakila/inventory.ibd | 19 | 360448 | 18970.9474 | 0 | 0 | 0.0000 | 360448 | 0.00 | |
/usr/share/mysql-8.0/russian/errmsg.sys | 3 | 318782 | 106260.6667 | 0 | 0 | 0.0000 | 318782 | 0.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/korean/errmsg.sys | 3 | 306547 | 102182.3333 | 0 | 0 | 0.0000 | 306547 | 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/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 |
|