Pick our brains...

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.