I noticed there is some page caching functionality in Midgard. I found in the file /etc/apache/midgard-data.conf the following:
MidgardPageCacheDir /var/www/midgard/page_cacheI don't understand what this means. If you turn it on, does it cache pages into that file and serve them from there? How do they get refreshed?
## Uncomment this if you want serve files instead of Midgard URLs
## where there's a match for both. You'd want to use this if you have
## active pages and you're using static dummy pages to force this
## behaviour. Note that this setting is apache-wide, not per-host.
# MidgardFavorFiles On
Most of our hits are to our front page. I was thinking of making it a published static page because it is quite complex and does a lot of calls to the database. Could I use this function to write the contents of the front page to a static file which gets refreshed whenever the content of the front page gets changed?
Many of our pages won't change very often but will be constructed using many database calls. Has anyone used an external caching engine with Midgard? What about Squid? Is it easy to specify what pages get cached and what don't and is it easy to refresh the cache, both manually and by cron job?
Finally, I wanted to ask about MySQL caching. I looked up the MySQL manual for version 4.0.1 at http://www.mysql.com/doc/en/Query_Cache_How.html
Has anyone looked at how well this works with Midgard? Can we assume if have this version of MySQL installed that this is all taken care of and MySQL is quietly caching away? Are there any issues with this version of MySQL and Midgard since it is kind of new?
Thanks
James
