Hi,
I was thinking of trying this module on a test site of mine but had a few questions before installing it.
1) Module home page refers to patching for cache serialisation and the path is for drupal 5.7 patch. In the patch folder of the module, however, I saw there were different patch files for different drupal versions. I am using Drupal 5.6 for example..do i still need to use 5.7 patch file?

2) My system for some reason does not like Opcode cache - I tried eaccelerator and my site started segfaulting every 5 minutes.

So for my cache router settings I plan to use

$conf['cache_inc'] = './sites/all/modules/cacherouter/cacherouter.inc';
$conf['cacherouter'] = array(
'default' => array(
'engine' => 'file',
'server' => array(),
'shared' => TRUE,
'prefix' => '',
'path' => '/tmp/filecache',
'static' => TRUE,
'fast_cache' => FALSE,
),
);

I am assuming when i set engine to File, the module will create cached files of the pages at the path specified and will server the user from that path untill something triggers it to refresh that cache of the file. Is that a correct assumption?
Drupal 6 has Static as FALSE..but should drupal 5 have it as TRUE?

3) I have been reading about sql query caching feature a lot on drupal, however, I have not as yet managed to find out, how to turn it on. Can someone guide me on that please.

Thanks

Manuj

Comments

slantview’s picture

Status: Active » Fixed

Hi Manuj!

Sorry it's taken a while to get back to you on this, somehow the issue got missed on my radar.

To answer your questions:

1. You can be pretty safe in either Drupal 6 or Drupal 5 turning static on, but some people were complaining that it was using double memory, so I made it optional. If memory use is not a concern of yours, I would recommend keeping it on.

2. To use mysql query caching, you need to turn on a couple variables in your my.cnf file. These can also be set during runtime, but typically you would want it in my.cnf so that they will be there when/if the mysql server restarts. To enable this, check out:

http://www.techiecorner.com/45/turn-on-mysql-query-cache-to-speed-up-mys...

The main thing to turn on is:


query-cache-type = 1
query-cache-size = 20M

That should do it.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.