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 | 458 | 2659678557888 | 2 | 875845344 | 274 | 62169099168 | 182 | 2596633613376 | |
/var/lib/mysql/ibdata1 | 194 | 1401056518224 | 20 | 10486778544 | 85 | 7138929600 | 89 | 1383430810080 | |
/var/lib/mysql/ib_logfile0 | 93 | 608747180976 | 6 | 616616352 | 42 | 2557814160 | 45 | 605572750464 | |
/var/lib/mysql/undo_001 | 605 | 452726753952 | 388 | 73629838128 | 179 | 11902332816 | 38 | 367194583008 | |
/var/lib/mysql/mysql.ibd | 545 | 413698777536 | 395 | 111023763312 | 106 | 2289152448 | 44 | 300385861776 | |
/var/lib/mysql/undo_002 | 582 | 403448813856 | 384 | 43063562784 | 158 | 4676524512 | 40 | 355708726560 | |
/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 | 32 | 220299633312 | 0 | 0 | 15 | 1516977792 | 17 | 218782655520 | |
/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 | 10 | 12420420672 | 5 | 12382627488 | 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 |
|