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 | 444 | 7372800 | 16605.4054 | 56 | 917504 | 16384.0000 | 8290304 | 11.07 | |
/var/lib/mysql/mysql.ibd | 378 | 6242304 | 16514.0317 | 106 | 1736704 | 16384.0000 | 7979008 | 21.77 | |
/var/lib/mysql/undo_002 | 405 | 6733824 | 16626.7259 | 55 | 901120 | 16384.0000 | 7634944 | 11.80 | |
/var/lib/mysql/ibdata1 | 18 | 2408448 | 133802.6667 | 29 | 3948544 | 136156.6897 | 6356992 | 62.11 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 0 | 0 | 0.0000 | 22 | 1015808 | 46173.0909 | 1015808 | 100.00 | |
/var/lib/mysql/ib_logfile1 | 2 | 66048 | 33024.0000 | 406 | 671744 | 1654.5419 | 737792 | 91.05 | |
/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/polish/errmsg.sys | 3 | 304436 | 101478.6667 | 0 | 0 | 0.0000 | 304436 | 0.00 | |
/usr/share/mysql-8.0/english/errmsg.sys | 3 | 303507 | 101169.0000 | 0 | 0 | 0.0000 | 303507 | 0.00 | |
/var/lib/mysql/baza/hobby.ibd | 0 | 0 | 0.0000 | 2 | 131072 | 65536.0000 | 131072 | 100.00 | |
/var/lib/mysql/baza/wpisy.ibd | 0 | 0 | 0.0000 | 2 | 131072 | 65536.0000 | 131072 | 100.00 | |
/var/lib/mysql/baza/osoby.ibd | 0 | 0 | 0.0000 | 2 | 131072 | 65536.0000 | 131072 | 100.00 | |
/var/lib/mysql/binlog.000008 | 33 | 122760 | 3720.0000 | 1 | 1 | 1.0000 | 122761 | 0.00 | |
/var/lib/mysql/#innodb_temp/temp_8.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_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/#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 | |
/var/lib/mysql/#innodb_temp/temp_2.ibt | 0 | 0 | 0.0000 | 3 | 114688 | 38229.3333 | 114688 | 100.00 |
|