Hello.
Background
We are a small web team who help mainly mom and pop type business get onto the net.
We are fairly new to drupal, but have built perhaps 80 or so sites with drupal. These are all mainly smaller websites (A few hundred pages at most).
A few clients also want us to help them convert some larger static websites into drupal. These probably have a few thousand pages at the moment and the sites get approximately 50,000 to 100,000 unique visitors a month.
Large cache files & limited disk space
One are that is concerning us is the large cache files/tables that drupal creates. Most of these sites have limited hard drive space. Perhaps 200mb up to 500mb.
In some cases some of these cache tables take up half the allocated disk space.
I have searched around on the forum for a while now, trying to get some definitive guide on caching and table sizes.
How do we manage the problem of large cache tables?
Basically, I want to understand this a little more before converting some of the larger sites over to drupal. I don't want the problem to arise of sites freezing/crashing because there isn't enough disk space available.
Is this something we would have to constantly monitor or are there any automatic drupal adjustments we can make to each site?
Why do the cache tables get so large?
It seems a little strange to me to have such large cache tables, which are way, way bigger than the actual content pages themselves.
Our server resources are currently limited and as we expand we will upgrade etc.
For each site at the moment we simply set the various out of the box caches on the admin/settings/performance page. We will probably start using the Boost module too and I presume this will create a large cache fiile too.
What can we do?
So is there some lower level performance recommedation or best practice suggestions somewhere regarding caching and database management etc?
I hope my questions make sense.
Thanks,
Colin
Comments
Can anybody help?
Can anybody help?
Sob, sob, sob... Does no one
Sob, sob, sob...
Does no one else get this problem?
Can anyone offer any tips for my questions above?
Please let me know if you do.
Thanks.
Unfortunately, I still
Unfortunately, I still haven't been able to get any help on my original questions in the first post.
Can anyone help?
Thanks
I now officially give up with
I now officially give up with this.
It's obviously not an issue for anyone in the whole drupal community except me. So I guess I am just really dumb.
Maybe Drupal 10 will be a little easier to understand. Then I may try it again :-(
1. under
1. under admin/settings/performance
enable drupal cache and set the time for cachce
2. scroll to the bottom and enable css and js optimization
3. enable cacherouter and authcache modules
(This is HUGE). Please read about them to best install
4. For anonymous users, install Boost.
5. Install opcode cache.
On my install, I am using eAccelerator and filecache. it is pretty quick and better for me than either Xcache or Apc.
don't give up.
There is a huge amount of information on performance tuning for Drupal on this forum and on google.com
http://SocialNicheGuru.com
Delivering inSITE(TM), we empower you to deliver the right product and the right message to the right NICHE at the right time across all product, marketing, and sales channels.
Hi, I have only just seen
Hi,
I have only just seen your reply.
Thank you for the words of encouragement and data.
The large ever growing cache files are still causing some pain.
I must admit to being rather surprised by the lack of data available, or responses on this issue.
Perhaps it isn't an issue for most people...
Thanks,
Colin