Welcome to Geeklog Thursday, December 13 2018 @ 01:23 am EST

Geeklog Under MySQL 4.0.x

  • Contributed by:
  • Views: 4,227
Announcements I am currently running Iowa Outdoors under MySQL 4. I did so to help address some performance issues with my 150MB database. MySQL 4's query cache feature will knock a lot of time off of your Geeklog queries if you tune it right. With a stock version of my-large.cnf I added these lines:

set-variable = query_cache_type=1
set-variable = query_cache_limit=2M
set-variable = query_cache_size=64MB

If you want to see how the cache is helping, from mysql client type "show status;" and look for the QCache_* variables. This took my page loads (from footer of GL page which isn't the best benchmark but works) from .94 seconds down to .54 seconds.