Pick our brains...

All posts tagged database

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 . . . Read more