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 | 442 | 2577422003376 | 2 | 947578368 | 261 | 56465803152 | 179 | 2520008621856 | |
/var/lib/mysql/ibdata1 | 190 | 1415857940112 | 20 | 7363167504 | 83 | 7223824080 | 87 | 1401270948528 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 104 | 749524206288 | 0 | 0 | 69 | 3694337328 | 35 | 745829868960 | |
/var/lib/mysql/ib_logfile0 | 79 | 549877278192 | 6 | 895090416 | 35 | 1835078256 | 38 | 547147109520 | |
/var/lib/mysql/undo_002 | 589 | 441364685520 | 384 | 37860635472 | 169 | 7581823920 | 36 | 395922226128 | |
/var/lib/mysql/undo_001 | 607 | 437642661984 | 388 | 75627219888 | 182 | 7530558288 | 37 | 354484883808 | |
/var/lib/mysql/mysql.ibd | 529 | 331263310752 | 434 | 107064394800 | 54 | 1148454384 | 41 | 223050461568 | |
/var/lib/mysql/ibtmp1 | 147 | 247393897872 | 0 | 0 | 143 | 35189968704 | 4 | 212203929168 | |
/var/lib/mysql/#innodb_temp/temp_1.ibt | 8 | 46881450000 | 0 | 0 | 3 | 272448528 | 5 | 46609001472 | |
/var/lib/mysql/#innodb_temp/temp_5.ibt | 8 | 42892521408 | 0 | 0 | 3 | 252636912 | 5 | 42639884496 | |
/var/lib/mysql/#innodb_temp/temp_8.ibt | 8 | 39399032640 | 0 | 0 | 3 | 306043584 | 5 | 39092989056 | |
/var/lib/mysql/binlog.000008 | 6 | 38142040464 | 0 | 0 | 2 | 36351744 | 4 | 38105688720 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 8 | 37845348288 | 0 | 0 | 3 | 253774752 | 5 | 37591573536 | |
/var/lib/mysql/#innodb_temp/temp_4.ibt | 8 | 37732009392 | 0 | 0 | 3 | 245425488 | 5 | 37486583904 | |
/var/lib/mysql/#innodb_temp/temp_7.ibt | 8 | 34753811136 | 0 | 0 | 3 | 247593984 | 5 | 34506217152 | |
/var/lib/mysql/#innodb_temp/temp_3.ibt | 8 | 34497982464 | 0 | 0 | 3 | 236775264 | 5 | 34261207200 | |
/var/lib/mysql/#innodb_temp/temp_6.ibt | 8 | 34033675104 | 0 | 0 | 3 | 790921296 | 5 | 33242753808 | |
/var/lib/mysql/#innodb_temp/temp_2.ibt | 8 | 33009527760 | 0 | 0 | 3 | 240788592 | 5 | 32768739168 | |
/var/lib/mysql/binlog.index | 13 | 19715286624 | 3 | 30702144 | 0 | 0 | 10 | 19684584480 | |
/var/lib/mysql/sakila/rental.ibd | 56 | 15359667840 | 51 | 15272090592 | 0 | 0 | 5 | 87577248 | |
/var/lib/mysql/sakila/payment.ibd | 53 | 7538232768 | 48 | 7507662624 | 0 | 0 | 5 | 30570144 | |
/var/lib/mysql/binlog.000007 | 604 | 6502646832 | 151 | 1681183680 | 1 | 8325504 | 452 | 4813137648 | |
/usr/share/mysql-8.0/french/errmsg.sys | 5 | 5896841808 | 3 | 3480820992 | 0 | 0 | 2 | 2416020816 | |
/usr/share/mysql-8.0/ukrainian/errmsg.sys | 5 | 5237379312 | 3 | 3011198784 | 0 | 0 | 2 | 2226180528 | |
/var/lib/mysql/sklepSerohenko/towar.ibd | 9 | 4587215424 | 4 | 1984730880 | 0 | 0 | 5 | 2602484544 |
|