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 | 369 | 2177430688224 | 2 | 875845344 | 219 | 61454710416 | 148 | 2115100132464 | |
/var/lib/mysql/ibdata1 | 164 | 1165050009552 | 20 | 10486778544 | 70 | 6279144432 | 74 | 1148284086576 | |
/var/lib/mysql/ib_logfile0 | 79 | 521131064784 | 6 | 616616352 | 35 | 2378692800 | 38 | 518135755632 | |
/var/lib/mysql/undo_001 | 583 | 395461843392 | 388 | 73629838128 | 164 | 4468081200 | 31 | 317363924064 | |
/var/lib/mysql/mysql.ibd | 514 | 366531907104 | 389 | 107176905792 | 88 | 2044132464 | 37 | 257310868848 | |
/var/lib/mysql/undo_002 | 549 | 332858362848 | 382 | 38017168992 | 134 | 4171724832 | 33 | 290669469024 | |
/var/lib/mysql/ibtmp1 | 147 | 283870051344 | 0 | 0 | 143 | 13175073120 | 4 | 270694978224 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 108 | 229200824160 | 0 | 0 | 99 | 87052046400 | 9 | 142148777760 | |
/var/lib/mysql/binlog.000008 | 18 | 125663177376 | 0 | 0 | 8 | 1345910016 | 10 | 124317267360 | |
/var/lib/mysql/PRUEBA/BASE2.ibd | 19 | 81295212768 | 0 | 0 | 10 | 321347136 | 9 | 80973865632 | |
/var/lib/mysql/#innodb_temp/temp_1.ibt | 8 | 42494025024 | 0 | 0 | 3 | 243442848 | 5 | 42250582176 | |
/var/lib/mysql/#innodb_temp/temp_5.ibt | 8 | 40693510704 | 0 | 0 | 3 | 287808048 | 5 | 40405702656 | |
/var/lib/mysql/#innodb_temp/temp_7.ibt | 8 | 37846260672 | 0 | 0 | 3 | 449449440 | 5 | 37396811232 | |
/var/lib/mysql/#innodb_temp/temp_3.ibt | 8 | 36982008624 | 0 | 0 | 3 | 252640608 | 5 | 36729368016 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 8 | 35736519456 | 0 | 0 | 3 | 378990480 | 5 | 35357528976 | |
/var/lib/mysql/#innodb_temp/temp_4.ibt | 8 | 35195988432 | 0 | 0 | 3 | 248983152 | 5 | 34947005280 | |
/var/lib/mysql/#innodb_temp/temp_2.ibt | 8 | 34962021600 | 0 | 0 | 3 | 256001856 | 5 | 34706019744 | |
/var/lib/mysql/#innodb_temp/temp_8.ibt | 8 | 33840026352 | 0 | 0 | 3 | 282027504 | 5 | 33557998848 | |
/var/lib/mysql/#innodb_temp/temp_6.ibt | 8 | 33441663552 | 0 | 0 | 3 | 277984080 | 5 | 33163679472 | |
/var/lib/mysql/sakila/customer.ibd | 14 | 21868547184 | 9 | 21821162880 | 0 | 0 | 5 | 47384304 | |
/var/lib/mysql/binlog.index | 13 | 17662672368 | 3 | 29480880 | 0 | 0 | 10 | 17633191488 | |
/var/lib/mysql/sakila/actor.ibd | 9 | 12411566640 | 4 | 12373773456 | 0 | 0 | 5 | 37793184 | |
/var/lib/mysql/sakila/payment.ibd | 55 | 8960297808 | 50 | 8927764560 | 0 | 0 | 5 | 32533248 | |
/usr/share/mysql-8.0/portuguese/errmsg.sys | 5 | 5675776656 | 3 | 3283416048 | 0 | 0 | 2 | 2392360608 | |
/usr/share/mysql-8.0/spanish/errmsg.sys | 5 | 5486304384 | 3 | 3447191088 | 0 | 0 | 2 | 2039113296 |
|