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 | 156 | 22904832 | 146825.8462 | 25346048 | 90.37 | |
/var/lib/mysql/ibtmp1 | 0 | 0 | 0.0000 | 143 | 14729216 | 103001.5105 | 14729216 | 100.00 | |
/var/lib/mysql/undo_001 | 388 | 6406144 | 16510.6804 | 456 | 7471104 | 16384.0000 | 13877248 | 53.84 | |
/var/lib/mysql/undo_002 | 384 | 6340608 | 16512.0000 | 403 | 6602752 | 16384.0000 | 12943360 | 51.01 | |
/var/lib/mysql/mysql.ibd | 411 | 6782976 | 16503.5912 | 312 | 5111808 | 16384.0000 | 11894784 | 42.98 | |
/var/lib/mysql/ib_logfile1 | 2 | 66048 | 33024.0000 | 989 | 1184256 | 1197.4277 | 1250304 | 94.72 | |
/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/sakila/inventory.ibd | 21 | 393216 | 18724.5714 | 0 | 0 | 0.0000 | 393216 | 0.00 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 0 | 0 | 0.0000 | 7 | 376832 | 53833.1429 | 376832 | 100.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/portuguese/errmsg.sys | 3 | 306467 | 102155.6667 | 0 | 0 | 0.0000 | 306467 | 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/swedish/errmsg.sys | 3 | 304360 | 101453.3333 | 0 | 0 | 0.0000 | 304360 | 0.00 | |
/usr/share/mysql-8.0/hungarian/errmsg.sys | 3 | 304148 | 101382.6667 | 0 | 0 | 0.0000 | 304148 | 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/film_actor.ibd | 15 | 294912 | 19660.8000 | 0 | 0 | 0.0000 | 294912 | 0.00 | |
/var/lib/mysql/Clientes/Vendas.ibd | 0 | 0 | 0.0000 | 10 | 262144 | 26214.4000 | 262144 | 100.00 | |
/var/lib/mysql/loja/Vendas.ibd | 0 | 0 | 0.0000 | 10 | 262144 | 26214.4000 | 262144 | 100.00 | |
/var/lib/mysql/loja/ItensVenda.ibd | 0 | 0 | 0.0000 | 9 | 245760 | 27306.6667 | 245760 | 100.00 | |
/var/lib/mysql/loja/Produtos.ibd | 0 | 0 | 0.0000 | 8 | 229376 | 28672.0000 | 229376 | 100.00 |
|