SELECT * FROM `x$io_global_by_file_by_latency`
|
file | total | total_latency | count_read | read_latency | count_write | write_latency | count_misc | misc_latency | |
---|---|---|---|---|---|---|---|---|---|
/var/lib/mysql/ib_logfile1 | 247 | 1228422351552 | 2 | 824441376 | 145 | 18852276960 | 100 | 1208745633216 | |
/var/lib/mysql/ibdata1 | 80 | 998681692272 | 20 | 5249547600 | 28 | 2536461840 | 32 | 990895682832 | |
/var/lib/mysql/ibtmp1 | 147 | 284040533040 | 0 | 0 | 143 | 20779516032 | 4 | 263261017008 | |
/var/lib/mysql/undo_002 | 525 | 180205730496 | 382 | 27788166912 | 125 | 3247724304 | 18 | 149169839280 | |
/var/lib/mysql/ib_logfile0 | 33 | 177772021680 | 6 | 476796144 | 12 | 661248192 | 15 | 176633977344 | |
/var/lib/mysql/undo_001 | 541 | 167634328752 | 388 | 61285277328 | 136 | 3194873616 | 17 | 103154177808 | |
/var/lib/mysql/mysql.ibd | 411 | 158661604992 | 371 | 101162342688 | 23 | 338114832 | 17 | 57161147472 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 49 | 119761877664 | 0 | 0 | 41 | 5366374992 | 8 | 114395502672 | |
/var/lib/mysql/#innodb_temp/temp_1.ibt | 8 | 48964368816 | 0 | 0 | 3 | 251524944 | 5 | 48712843872 | |
/var/lib/mysql/#innodb_temp/temp_3.ibt | 8 | 43089973872 | 0 | 0 | 3 | 241924320 | 5 | 42848049552 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 8 | 39568335312 | 0 | 0 | 3 | 286103664 | 5 | 39282231648 | |
/var/lib/mysql/binlog.000008 | 6 | 38519223600 | 0 | 0 | 2 | 47208480 | 4 | 38472015120 | |
/var/lib/mysql/#innodb_temp/temp_6.ibt | 8 | 37189731744 | 0 | 0 | 3 | 234719760 | 5 | 36955011984 | |
/var/lib/mysql/#innodb_temp/temp_8.ibt | 8 | 37023554304 | 0 | 0 | 3 | 254907840 | 5 | 36768646464 | |
/var/lib/mysql/#innodb_temp/temp_7.ibt | 8 | 35959155936 | 0 | 0 | 3 | 260956080 | 5 | 35698199856 | |
/var/lib/mysql/#innodb_temp/temp_2.ibt | 8 | 32444419920 | 0 | 0 | 3 | 255875664 | 5 | 32188544256 | |
/var/lib/mysql/#innodb_temp/temp_4.ibt | 8 | 30710272560 | 0 | 0 | 3 | 188649120 | 5 | 30521623440 | |
/var/lib/mysql/#innodb_temp/temp_5.ibt | 8 | 30346963680 | 0 | 0 | 3 | 144753312 | 5 | 30202210368 | |
/var/lib/mysql/binlog.index | 13 | 23326557408 | 3 | 32727552 | 0 | 0 | 10 | 23293829856 | |
/usr/share/mysql-8.0/spanish/errmsg.sys | 5 | 8287315872 | 3 | 3323824416 | 0 | 0 | 2 | 4963491456 | |
/usr/share/mysql-8.0/italian/errmsg.sys | 5 | 5374327200 | 3 | 2957492736 | 0 | 0 | 2 | 2416834464 | |
/var/lib/mysql/sakila/inventory.ibd | 21 | 5328114000 | 16 | 5279748144 | 0 | 0 | 5 | 48365856 | |
/var/lib/mysql/binlog.000007 | 52 | 3504600000 | 13 | 1261678176 | 1 | 5831760 | 38 | 2237090064 | |
/usr/share/mysql-8.0/french/errmsg.sys | 5 | 2851058496 | 3 | 1062501792 | 0 | 0 | 2 | 1788556704 | |
/usr/share/mysql-8.0/russian/errmsg.sys | 5 | 2824518576 | 3 | 2118640656 | 0 | 0 | 2 | 705877920 |
|