Mysql Optimizations & Server Database Tuning
A few tasty tidbits, to jog the memory about database & server optimizations…
To be expanded. Share your thoughts and suggestions!
Example Server:
Memory Available: 1,751,724k total
Handy Queries:
mysql> SHOW VARIABLES LIKE '%cache%'; mysql> SHOW STATUS LIKE 'Qcache%';
My.cnf Tweaks:
; QUERY CACHE... query_cache_size = 500M query_cache_type = 1 query_cache_limit = 1M
And yes, the “query_cache_size” above is probably too big, and would be prone to an invalidation flood.