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 | 1127 | 5606599272384 | 2 | 930008112 | 687 | 130553881920 | 438 | 5475115382352 | |
/var/lib/mysql/ibdata1 | 271 | 2689924300800 | 20 | 9164893056 | 126 | 11454218160 | 125 | 2669305189584 | |
/var/lib/mysql/undo_001 | 1076 | 704895415488 | 388 | 77390348640 | 632 | 14656311120 | 56 | 612848755728 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 286 | 659864457120 | 0 | 0 | 246 | 3994344288 | 40 | 655870112832 | |
/var/lib/mysql/ib_logfile0 | 107 | 645471469632 | 6 | 884306544 | 49 | 4331723616 | 52 | 640255439472 | |
/var/lib/mysql/undo_002 | 1043 | 610117499904 | 384 | 34345489728 | 601 | 8996371296 | 58 | 566775638880 | |
/var/lib/mysql/mysql.ibd | 559 | 369390612096 | 403 | 89916152304 | 100 | 2054277984 | 56 | 277420181808 | |
/var/lib/mysql/ibtmp1 | 147 | 271806930384 | 0 | 0 | 143 | 15075039936 | 4 | 256731890448 | |
/var/lib/mysql/#innodb_temp/temp_1.ibt | 8 | 70733517888 | 0 | 0 | 3 | 241503504 | 5 | 70492014384 | |
/var/lib/mysql/binlog.000008 | 10 | 69378853104 | 0 | 0 | 4 | 407653488 | 6 | 68971199616 | |
/var/lib/mysql/employeedb/employee.ibd | 13 | 58425154656 | 0 | 0 | 7 | 276077472 | 6 | 58149077184 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 11 | 49708637088 | 0 | 0 | 5 | 519966480 | 6 | 49188670608 | |
/var/lib/mysql/#innodb_temp/temp_5.ibt | 8 | 43075303920 | 0 | 0 | 3 | 532035504 | 5 | 42543268416 | |
/var/lib/mysql/#innodb_temp/temp_3.ibt | 8 | 42185145552 | 0 | 0 | 3 | 484231968 | 5 | 41700913584 | |
/var/lib/mysql/#innodb_temp/temp_7.ibt | 8 | 41136037536 | 0 | 0 | 3 | 462503184 | 5 | 40673534352 | |
/var/lib/mysql/#innodb_temp/temp_4.ibt | 8 | 39788027664 | 0 | 0 | 3 | 468077280 | 5 | 39319950384 | |
/var/lib/mysql/#innodb_temp/temp_6.ibt | 8 | 36691290240 | 0 | 0 | 3 | 480924048 | 5 | 36210366192 | |
/var/lib/mysql/#innodb_temp/temp_8.ibt | 8 | 36224725152 | 0 | 0 | 3 | 307694112 | 5 | 35917031040 | |
/var/lib/mysql/#innodb_temp/temp_2.ibt | 8 | 35535348288 | 0 | 0 | 3 | 701323392 | 5 | 34834024896 | |
/var/lib/mysql/binlog.index | 13 | 27833452944 | 3 | 31997856 | 0 | 0 | 10 | 27801455088 | |
/var/lib/mysql/sakila/rental.ibd | 58 | 6637064544 | 53 | 6602787840 | 0 | 0 | 5 | 34276704 | |
/usr/share/mysql-8.0/spanish/errmsg.sys | 5 | 5617906800 | 3 | 1880670528 | 0 | 0 | 2 | 3737236272 | |
/var/lib/mysql/pw/credenciales.ibd | 9 | 5243347824 | 4 | 5196370080 | 0 | 0 | 5 | 46977744 | |
/var/lib/mysql/sakila/actor.ibd | 10 | 4680918528 | 5 | 4629018768 | 0 | 0 | 5 | 51899760 | |
/var/lib/mysql/test19/voiture.ibd | 10 | 4499445984 | 5 | 2561223984 | 0 | 0 | 5 | 1938222000 |
|