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:

Setup Windows Local Account without the Internet

During the Windows setup,  On the WiFi screen, press SHIFT + F10  or  FN + SHIFT + F10  This will open the command prompt window with admini...