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 | 135 | 34308096 | 254134.0444 | 36749312 | 93.36 | |
/var/lib/mysql/undo_002 | 392 | 6471680 | 16509.3878 | 716 | 11730944 | 16384.0000 | 18202624 | 64.45 | |
/var/lib/mysql/undo_001 | 391 | 6455296 | 16509.7084 | 693 | 11354112 | 16384.0000 | 17809408 | 63.75 | |
/var/lib/mysql/mysql.ibd | 441 | 7274496 | 16495.4558 | 473 | 7749632 | 16384.0000 | 15024128 | 51.58 | |
/var/lib/mysql/ibtmp1 | 0 | 0 | 0.0000 | 143 | 14729216 | 103001.5105 | 14729216 | 100.00 | |
/var/lib/mysql/ib_logfile1 | 2 | 66048 | 33024.0000 | 3047 | 5779968 | 1896.9373 | 5846016 | 98.87 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 0 | 0 | 0.0000 | 130 | 3702784 | 28482.9538 | 3702784 | 100.00 | |
/usr/share/mysql-8.0/russian/errmsg.sys | 3 | 318782 | 106260.6667 | 0 | 0 | 0.0000 | 318782 | 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/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/czech/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/#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/sys/sys_config.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/#innodb_temp/temp_3.ibt | 0 | 0 | 0.0000 | 3 | 114688 | 38229.3333 | 114688 | 100.00 |
|