GoFuckYourself.com - Adult Webmaster Forum - View Single Post - optimized MYSQL config?? (db running slow)

borked · 10-01-2006, 10:49 PM

Absolutely turn on the query cache

Code:

query_cache_type=1
query_cache_limit=2M
query_cache_size=64M

and log long/slow queries

Code:

log_slow_queries=/var/log/mysql/slow-queries.log
long_query_time=3

The cache can speed up complex queries requiring multiple connections amazingly...I've one query that w/o the cache takes 35 secs (2.5million entries), w/ the cache is immediate.

10-01-2006, 10:49 PM
borked Totally Borked Industry Role: Join Date: Feb 2005 Posts: 6,284	Absolutely turn on the query cache Code: query_cache_type=1 query_cache_limit=2M query_cache_size=64M and log long/slow queries Code: log_slow_queries=/var/log/mysql/slow-queries.log long_query_time=3 The cache can speed up complex queries requiring multiple connections amazingly...I've one query that w/o the cache takes 35 secs (2.5million entries), w/ the cache is immediate. __________________ For coding work - hit me up on andy // borkedcoder // com (consider figuring out the email as test #1) All models are wrong, but some are useful. George E.P. Box. p202