Welcome to Geeklog, Anonymous Thursday, February 22 2024 @ 10:44 pm EST

Geeklog Under MySQL 4.0.x

  • Monday, March 24 2003 @ 11:56 pm EST
  • Contributed by:
  • Views: 5,466
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.