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 | 260 | 41517056 | 159680.9846 | 43958272 | 94.45 | |
/var/lib/mysql/mysql.ibd | 405 | 6684672 | 16505.3630 | 820 | 13434880 | 16384.0000 | 20119552 | 66.78 | |
/var/lib/mysql/undo_001 | 389 | 6422528 | 16510.3548 | 693 | 11354112 | 16384.0000 | 17776640 | 63.87 | |
/var/lib/mysql/undo_002 | 385 | 6356992 | 16511.6675 | 667 | 10928128 | 16384.0000 | 17285120 | 63.22 | |
/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 | 86 | 4030464 | 46865.8605 | 4030464 | 100.00 | |
/var/lib/mysql/ib_logfile1 | 2 | 66048 | 33024.0000 | 2350 | 3770368 | 1604.4119 | 3836416 | 98.28 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 0 | 0 | 0.0000 | 8 | 393216 | 49152.0000 | 393216 | 100.00 | |
/var/lib/mysql/db_dream_estates/Tenant.ibd | 0 | 0 | 0.0000 | 15 | 344064 | 22937.6000 | 344064 | 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/ukrainian/errmsg.sys | 3 | 313356 | 104452.0000 | 0 | 0 | 0.0000 | 313356 | 0.00 | |
/var/lib/mysql/db_dream_estates/Lease.ibd | 0 | 0 | 0.0000 | 13 | 311296 | 23945.8462 | 311296 | 100.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/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 | |
/usr/share/mysql-8.0/polish/errmsg.sys | 3 | 304436 | 101478.6667 | 0 | 0 | 0.0000 | 304436 | 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/db_dream_estates/Payment.ibd | 0 | 0 | 0.0000 | 12 | 294912 | 24576.0000 | 294912 | 100.00 | |
/var/lib/mysql/HR/EMPLOYEES.ibd | 0 | 0 | 0.0000 | 9 | 245760 | 27306.6667 | 245760 | 100.00 |
|