Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 07:09 am EDT

Geeklog Under MySQL 4.0.x

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