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 | 2393 | 13151313850752 | 2 | 932354544 | 1479 | 330205455888 | 912 | 12820176040320 | |
/var/lib/mysql/ibdata1 | 507 | 3897557583216 | 20 | 6081124896 | 247 | 26042967984 | 240 | 3865433490336 | |
/var/lib/mysql/ib_logfile0 | 207 | 1468419776208 | 6 | 758861664 | 99 | 4960359360 | 102 | 1462700555184 | |
/var/lib/mysql/undo_002 | 1287 | 964427474208 | 384 | 30660822720 | 797 | 18208874112 | 106 | 915557777376 | |
/var/lib/mysql/undo_001 | 1392 | 913237879488 | 388 | 50068650720 | 902 | 19561967568 | 102 | 843607261200 | |
/var/lib/mysql/mysql.ibd | 871 | 853856654112 | 418 | 94381020096 | 335 | 8628139872 | 118 | 750847494144 | |
/var/lib/mysql/binlog.000008 | 100 | 807280539120 | 0 | 0 | 49 | 2956183296 | 51 | 804324355824 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 94 | 534330799728 | 0 | 0 | 63 | 3171590928 | 31 | 531159208800 | |
/var/lib/mysql/ibtmp1 | 147 | 251500724640 | 0 | 0 | 143 | 28671081648 | 4 | 222829642992 | |
/var/lib/mysql/LOJA/SituacoesVenda.ibd | 13 | 195214542864 | 0 | 0 | 7 | 17641841184 | 6 | 177572701680 | |
/var/lib/mysql/loja/Vendas.ibd | 19 | 146613612288 | 0 | 0 | 10 | 320517120 | 9 | 146293095168 | |
/var/lib/mysql/#innodb_temp/temp_8.ibt | 22 | 139458923472 | 0 | 0 | 11 | 687721584 | 11 | 138771201888 | |
/var/lib/mysql/loja/ItensVenda.ibd | 17 | 133570008528 | 0 | 0 | 9 | 217815312 | 8 | 133352193216 | |
/var/lib/mysql/loja/Produtos.ibd | 20 | 126865160928 | 0 | 0 | 11 | 196808304 | 9 | 126668352624 | |
/var/lib/mysql/LOJA/Vendas.ibd | 19 | 117359952864 | 0 | 0 | 10 | 351455280 | 9 | 117008497584 | |
/var/lib/mysql/LOJA/Produtos.ibd | 18 | 106402049952 | 0 | 0 | 10 | 404190864 | 8 | 105997859088 | |
/var/lib/mysql/LOJA/ItensVenda.ibd | 17 | 97585727712 | 0 | 0 | 9 | 354697200 | 8 | 97231030512 | |
/var/lib/mysql/LOJA/Categorias.ibd | 15 | 94582090416 | 0 | 0 | 8 | 472689360 | 7 | 94109401056 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 11 | 69067937664 | 0 | 0 | 5 | 1283227968 | 6 | 67784709696 | |
/var/lib/mysql/LOJA/FormasPagamento.ibd | 15 | 67634919792 | 0 | 0 | 8 | 4832665728 | 7 | 62802254064 | |
/var/lib/mysql/LOJA/Clientes.ibd | 15 | 65051778000 | 0 | 0 | 8 | 242448096 | 7 | 64809329904 | |
/var/lib/mysql/loja/Clientes.ibd | 15 | 64990772352 | 0 | 0 | 8 | 604517232 | 7 | 64386255120 | |
/var/lib/mysql/loja/SituacoesVenda.ibd | 13 | 64343019840 | 0 | 0 | 7 | 370637520 | 6 | 63972382320 | |
/var/lib/mysql/loja/FormasPagamento.ibd | 13 | 58854590784 | 0 | 0 | 7 | 309850992 | 6 | 58544739792 | |
/var/lib/mysql/loja/Categorias.ibd | 15 | 54680510544 | 0 | 0 | 8 | 315257712 | 7 | 54365252832 |
|