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 problem can be solved from the same level of consciousness that created it.” Albert Einstein (1879-1955)
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...
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...
No comments:
Post a Comment