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:

Connect PowerBI to SQL Server - TrustServerCertificate

Under the server that Power BI installed,  Go to System Properties -> Advanced -> Environment Variables  Add this Variable Name PBI_S...