Wednesday, 23 July 2014

Enable the query cache in MySQL to Improve Performance

To see the cache size: 
mysql> SHOW VARIABLES LIKE 'query_cache_size';  

 
To manage the cache size:
mysql> SET GLOBAL query_cache_size = 16777216;

 
More... 


 

No comments:

SQL: Generate a range of numbers

SELECT ones.n + 10*tens.n + 100*hundreds.n + 1000*thousands.n FROM       (VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) ones(n),      (VALU...