Cache keeps filling up MySQL datebase

Post by **Oliver Georgi** » Sat 3. Sep 2005, 10:35

The reason for filling the cache is to have "indexed" content for the new search. Filling cache content is based on unique URL. So maybe you use diffent kind of URLs or something like that - or additional changing GET values. Maybe check that.

Oliver

jsw_nz · Post by **jsw_nz** » Fri 11. Nov 2005, 23:44

My real concern is providing a solution for client, since they are pretty simple minded. Namely they would be confused if having made changes to content, they could not immediately view them. Just that simple.

Also a wee bit confusing to me as well. (1.2.5)

config.inc.php
$phpwcms["cache_timeout"] = 0;

site structure (website root level - home page)
cache: (checkbox) X off

article - home page
cache: (checkbox) X off

and as coopersred suggested:

index.php
$cache_update = 0;
$cache_insert = 0;

still no luck

To be honest, Oliver, I think this is a great feature, cache control, but I think it needs some polishing. As far as things right now...

even using the 'delete cache' in backend is not resolving this problem.

At the end of the day, the only thing I can suggest to client is to use the CNTRL+F5 strategy inside IE, but I am confused as to when and where the updates appear to site visitors......hmm....

Has the new CVS released adressed this?

cheers

Post by **Oliver Georgi** » Sat 12. Nov 2005, 03:10

I don't understand your post and what you want to say

What is the problem?

Each time your client is doing a content change in the backend cache timeout is reset. So they will always have updated content and browser refresh isn't neccessary (should be).

Oliver

jsw_nz · Post by **jsw_nz** » Sat 12. Nov 2005, 04:59

Hi Oliver,

Well basically any change to content in homepage (root) does not immediately show up. Very strange really, since I set all the above settings to completely bypass caching.

suggestions?

site:
http://www.southernmaoribusiness.org.nz/

if I make changes to 'text' in backend to homepage,
they do not display the update in public site..

Post by **Oliver Georgi** » Sat 12. Nov 2005, 10:16

normally this is impossible because each time an update in the backend is done the cache timeout in database is reset. Maybe there is a squid or another proxy responsible for that.

Oliver

jsw_nz · Post by **jsw_nz** » Sat 12. Nov 2005, 10:46

That is possible, will have to look into that....

I had discussed upgrading to 1.2.6 with Pappnase, but I am guessing that the same situation will occur. Very strange, really. One thing to mention, but I do not think this is related. I set up the site using:

$phpwcms["site"] = "http://unix301.tm136.taylormade.net.nz/";

because the client had yet to decide on a domain name...
now had been changed to:

$phpwcms["site"] = "http://www.southernmaoribusiness.org.nz/";

could this change have affected 'something else' that I am not aware of? ...because during deving under the first site definition (taylormade.net.nz), I do not remember this problem....

the original setup generated $_SERVER['DOCUMENT_ROOT'] as:
/hsphere/local/home/unix301/unix301.tm136.taylormade.net.nz'

but now as far as the server is concerned all files are here:
/hsphere/local/home/southernmaoribusiness.org.nz'

would uncommented the $_SERVER['DOCUMENT_ROOT'] be any benefit?

Just cannot understand this situation.

Post by **Oliver Georgi** » Sat 12. Nov 2005, 11:36

you have to replace DOC_ROOT by current path.

Domain name has nothing to do with it - because system checks always against current URL. So try to empty cache first in admin section.

And it's always good to use:

Code: Select all

$phpwcms["site"] = "http://".$_SERVER['SERVER_NAME']."/";

I will make another change to cached content where a hash will be used to compare against content. Might be better than against URI.

Oliver

jsw_nz · Post by **jsw_nz** » Sun 13. Nov 2005, 09:55

Thanks Oliver...will sort this out

I had a wee question about SSL in Wcms - is it planned to be implemented?

I just posted source (Marcus and Me) of shopping cart and it works except for SSL implementation.

I wanted to ask a BIG favor and have you take a look at functionality.
http://www.gripfast.co.nz/index.php?balls_rugby_union
(unfortunately this cart will be removed later this week)

I posted the source here:
http://intermundi.webbiznz.co.nz/wcms/w ... cation.zip

No where near what you might have in mind, since you did mention a simple cart down the line.
I just wanted to ask if you might lend any info about SSL....
since this hack is ready to go except for this aspect.

Viele Danke,

Post by **Oliver Georgi** » Sun 13. Nov 2005, 10:25

If you need SSL just change

Code: Select all

$phpwcms["site"] = "http://".$_SERVER['SERVER_NAME']."/";

to

Code: Select all

$phpwcms["site"] = "https://".$_SERVER['SERVER_NAME']."/";

Maybe not the best solution - but it is working.

It might also be possible to build a custom workaround to change "https://". Use "frontend_init" for this and make a check against structure level or level ID or whatever.

Maybe working like this:

Code: Select all

if($aktion[0] == 5) { // 5 = structure level ID
  $phpwcms["site"] = "https://".$_SERVER['SERVER_NAME']."/";
} else {
  $phpwcms["site"] = "http://".$_SERVER['SERVER_NAME']."/";
}

or implement a check which redirects to the right protocol.

Oliver

jsw_nz · Post by **jsw_nz** » Mon 14. Nov 2005, 23:13

Thanks Oliver,
the cache issue has been resolved by using:

Code: Select all

$phpwcms["site"] = "http://".$_SERVER['SERVER_NAME']."/";

I wanted to ask a question, regarding the summary interface that uses the FCK 2 Editor. The client has asked for more working area in summary interface in which to add content. (WYSIWYG and Text w/Images are fine). Here is screen capture of summary section (FCK2)

I wanted to ask if you might point me in the right direction towards making this modification, basically increasing its height.

Cheers & Thanks,

UPDATE:
Ok, went in and found it, basically the WYSIWYG array declared in

inc/inc_tmpl/article.editsummary.tmpl.php

$wysiwyg_editor = array(
'value' => $article["article_summary"],
'field' => 'article_summary',
'height' => '550px',
'width' => '440px',
'rows' => '15',
'editor' => $_SESSION["WYSIWYG_EDITOR"],
'lang' => 'en'
);

Post by **Oliver Georgi** » Mon 14. Nov 2005, 23:17

check cnt1.inc.php

Newest release should have more height there. Check CVS.

Oliver

pico · Post by **pico** » Tue 15. Nov 2005, 08:28

or use the 'Full-Page' Plug-In for FCKeditor -> here

or use my -> Pakage

jsw_nz · Post by **jsw_nz** » Tue 15. Nov 2005, 22:19

Thanks Pico,
I will use it on my next project.
Great contributon to Wcms, btw

shiny · Post by **shiny** » Wed 30. Nov 2005, 17:33

Just a quick note to mention that I've had this problem on my site, too - I thought that it was my webserver, but after some investigation I discovered that MySQL was hanging when trying to update the 55MB(!) phpwcms_cache table, and killing the site for half an hour at the time until the zombie processes disappeared.

I've applied the fix on the previous page, which should hopefully sort it.

frold · Post by **frold** » Wed 30. Nov 2005, 19:53

Yep this solve it

Thanks... I was looking for a solution!!

coopersred wrote:Yes every url seems to be unique

But I seemed to have solved the problem or at least found a work around. In the original index.php file lines 89-92 were set like this:

//db based page caching
$cache_enabled = 0;
$cache_update = 1;
$cache_insert = 1;

and when set like that every page access filled the table phpcms_cache

When I changed lines 89-92 to this

//db based page caching
$cache_enabled = 0;
$cache_update = 0;
$cache_insert = 0;

it stopped my cache from filling up.

Don't know if this will cause me problems but so far so good. Maybe i've found the cache turn off swicth??