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 | 2436 | 11780823158544 | 2 | 918402144 | 1640 | 349178767872 | 794 | 11430725988528 | |
/var/lib/mysql/ibdata1 | 427 | 3308768589984 | 20 | 11113184544 | 202 | 13610418096 | 205 | 3284044987344 | |
/var/lib/mysql/mysql.ibd | 643 | 1310907035328 | 363 | 760123345872 | 180 | 9694672416 | 100 | 541089017040 | |
/var/lib/mysql/ib_logfile0 | 179 | 1241416552992 | 6 | 737573760 | 85 | 4196307456 | 88 | 1236482671776 | |
/var/lib/mysql/undo_002 | 867 | 825114844752 | 385 | 40640715456 | 403 | 23487850320 | 79 | 760986278976 | |
/var/lib/mysql/undo_001 | 931 | 777943662144 | 388 | 76678074528 | 460 | 17316911040 | 83 | 683948676576 | |
/var/lib/mysql/binlog.000008 | 70 | 486491442624 | 0 | 0 | 34 | 2247519120 | 36 | 484243923504 | |
/var/lib/mysql/#innodb_temp/temp_8.ibt | 77 | 422327415840 | 0 | 0 | 52 | 2036876160 | 25 | 420290539680 | |
/var/lib/mysql/ibtmp1 | 147 | 253982054832 | 0 | 0 | 143 | 21303639456 | 4 | 232678415376 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 13 | 96941827488 | 0 | 0 | 6 | 178481424 | 7 | 96763346064 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 11 | 83127632544 | 0 | 0 | 5 | 381726576 | 6 | 82745905968 | |
/var/lib/mysql/binlog.index | 13 | 43116796800 | 3 | 1976365776 | 0 | 0 | 10 | 41140431024 | |
/var/lib/mysql/#innodb_temp/temp_6.ibt | 8 | 41505357168 | 0 | 0 | 3 | 244374240 | 5 | 41260982928 | |
/var/lib/mysql/#innodb_temp/temp_1.ibt | 8 | 40871611440 | 0 | 0 | 3 | 316747728 | 5 | 40554863712 | |
/var/lib/mysql/#innodb_temp/temp_4.ibt | 8 | 40115076672 | 0 | 0 | 3 | 273558912 | 5 | 39841517760 | |
/var/lib/mysql/#innodb_temp/temp_5.ibt | 8 | 38555258016 | 0 | 0 | 3 | 289000272 | 5 | 38266257744 | |
/var/lib/mysql/#innodb_temp/temp_7.ibt | 8 | 35020489680 | 0 | 0 | 3 | 254905728 | 5 | 34765583952 | |
/var/lib/mysql/#innodb_temp/temp_2.ibt | 8 | 33462192192 | 0 | 0 | 3 | 217509072 | 5 | 33244683120 | |
/var/lib/mysql/#innodb_temp/temp_3.ibt | 8 | 32561637504 | 0 | 0 | 3 | 219917280 | 5 | 32341720224 | |
/usr/share/mysql-8.0/italian/errmsg.sys | 5 | 6243485424 | 3 | 2869420224 | 0 | 0 | 2 | 3374065200 | |
/usr/share/mysql-8.0/russian/errmsg.sys | 5 | 4733107632 | 3 | 2431489632 | 0 | 0 | 2 | 2301618000 | |
/usr/share/mysql-8.0/spanish/errmsg.sys | 5 | 4452106560 | 3 | 955404384 | 0 | 0 | 2 | 3496702176 | |
/usr/share/mysql-8.0/romanian/errmsg.sys | 5 | 3696118272 | 3 | 1843415376 | 0 | 0 | 2 | 1852702896 | |
/var/lib/mysql/binlog.000007 | 312 | 3501822192 | 78 | 1310489136 | 1 | 8968608 | 233 | 2182364448 | |
/usr/share/mysql-8.0/japanese/errmsg.sys | 5 | 2999410128 | 3 | 1952728272 | 0 | 0 | 2 | 1046681856 |
|