Hello, our online shop (PartBox Performance Parts) is doing this, regardless of setting the cache to FileSystem or Database.
It works great for a day or two, then the site just starts getting blank pages. The memory limit in PHP is already set to 32M and I don't appear to be able to increase it (shared hosting). The server logs confirm that it is a memory problem when the unserialize() function tries to run:
part-box.com [Wed Mar 10 08:45:24 2010] [error] [client 220.127.116.11] PHP Fatal error:
Out of memory (allocated 33030144) (tried to allocate 39 bytes) in
/home/sites/part-box.com/public_html/includes/modules/ultimate_seo_urls5/classes/Usu_Cache_Database.php on line 69
The compressed/serialised data with the cache is 413KB. You can see the data here: 1_usu_cache.cache
Would the Memcached option do the same and eventually get too big and exhaust the memory? Resetting the cache fixes the problem, but then it is only a matter of time before the problem appears again. We do have a very large catalogue, but surely there needs to be a more efficient way of dealing with this issue, which seems like a few people are having. Any solutions or ideas?
On another note, we were getting the following line appear in our server error logs, which I fixed by putting the @ symbol before the call to mysql_affected_rows(). Not sure whether this is just masking a problem or not:
part-box.com [Wed Mar 10 10:18:04 2010] [error] [client 18.104.22.168] PHP Warning:
mysql_affected_rows() [<a href='function.mysql-affected-rows'>function.mysql-affected-rows</a>]:
A link to the server could not be established in
/home/sites/part-box.com/public_html/includes/modules/ultimate_seo_urls5/classes/Usu_Cache_Database.php on line 46