New answers tagged

0

So, will the SQL server do this immediately after my stats are updated or will it wait until a corresponding query is executed to rebuild the cache ? NO, SQL Server would not do it immediately. Rebuilding indexes does lot of page movements and so does stats update. There is quite a chance that pages already present in memory, before index operation, would ...


0

Some of what MySQLTuner says is bogus. Here are the things that seem bad: You are using MyISAM instead of InnoDB; this is generally sub-optimal. Fragmented tables -- bogus. There may be some MyISAM tables that could use OPTIMIZE, but probably not. 3GB of InnoDB tables, yet the buffer_pool is much bigger. Lower innodb_buffer_pool_size to 3500M and the ...



Top 50 recent answers are included