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 | 144 | 787901278032 | 2 | 670857792 | 84 | 20785948656 | 58 | 766444471584 | |
/var/lib/mysql/ibdata1 | 82 | 410539741920 | 22 | 4991517168 | 28 | 1121053824 | 32 | 404427170928 | |
/var/lib/mysql/ib_logfile0 | 41 | 199966700736 | 6 | 305119056 | 16 | 991985280 | 19 | 198669596400 | |
/var/lib/mysql/mysql.ibd | 498 | 187017051408 | 419 | 94912126320 | 58 | 639308208 | 21 | 91465616880 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 120 | 175936117632 | 0 | 0 | 108 | 1132359360 | 12 | 174803758272 | |
/var/lib/mysql/binlog.000010 | 14 | 97220430912 | 0 | 0 | 6 | 547858080 | 8 | 96672572832 | |
/var/lib/mysql/perpustakaan/pinjaman.ibd | 13 | 85524497520 | 0 | 0 | 7 | 158427456 | 6 | 85366070064 | |
/var/lib/mysql/undo_002 | 425 | 84990160464 | 387 | 28154956896 | 23 | 584973312 | 15 | 56250230256 | |
/var/lib/mysql/undo_001 | 424 | 84844116720 | 384 | 48687258048 | 25 | 452739936 | 15 | 35704118736 | |
/var/lib/mysql/ibtmp1 | 147 | 80732594448 | 0 | 0 | 143 | 13361719008 | 4 | 67370875440 | |
/var/lib/mysql/#innodb_temp/temp_8.ibt | 8 | 46763062368 | 0 | 0 | 3 | 241643952 | 5 | 46521418416 | |
/var/lib/mysql/#innodb_temp/temp_6.ibt | 8 | 33376600752 | 0 | 0 | 3 | 336291120 | 5 | 33040309632 | |
/var/lib/mysql/#innodb_temp/temp_4.ibt | 8 | 30236615376 | 0 | 0 | 3 | 171565152 | 5 | 30065050224 | |
/var/lib/mysql/#innodb_temp/temp_5.ibt | 8 | 29414303952 | 0 | 0 | 3 | 290849328 | 5 | 29123454624 | |
/var/lib/mysql/#innodb_temp/temp_7.ibt | 8 | 28469662848 | 0 | 0 | 3 | 319328064 | 5 | 28150334784 | |
/var/lib/mysql/#innodb_temp/temp_1.ibt | 8 | 28050714384 | 0 | 0 | 3 | 269928384 | 5 | 27780786000 | |
/var/lib/mysql/#innodb_temp/temp_2.ibt | 8 | 26388607872 | 0 | 0 | 3 | 230015808 | 5 | 26158592064 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 8 | 25812248880 | 0 | 0 | 3 | 99425040 | 5 | 25712823840 | |
/var/lib/mysql/#innodb_temp/temp_3.ibt | 8 | 25414994352 | 0 | 0 | 3 | 135944160 | 5 | 25279050192 | |
/var/lib/mysql/binlog.000007 | 165 | 4527178128 | 42 | 1841853552 | 0 | 0 | 123 | 2685324576 | |
/usr/share/mysql-8.0/polish/errmsg.sys | 5 | 3965244096 | 3 | 2034903552 | 0 | 0 | 2 | 1930340544 | |
/usr/share/mysql-8.0/french/errmsg.sys | 5 | 3763539648 | 3 | 1855891488 | 0 | 0 | 2 | 1907648160 | |
/usr/share/mysql-8.0/russian/errmsg.sys | 5 | 3145931184 | 3 | 1191144240 | 0 | 0 | 2 | 1954786944 | |
/usr/share/mysql-8.0/italian/errmsg.sys | 5 | 2456842080 | 3 | 886437024 | 0 | 0 | 2 | 1570405056 | |
/usr/share/mysql-8.0/portuguese/errmsg.sys | 5 | 2328340608 | 3 | 931009200 | 0 | 0 | 2 | 1397331408 |
|