Hi all,
I just wanted to share my experience about caching with you.
We've a dedicated server with several websites, serving a total of about 150-200 GB a month and we made extensive use of TOuputCache.
First our cache-module was SQLite, which worked fine while developing, but when it came to traffic peaks our whole server screwed up - the last thing I saw before a manual reset was a load of 162(!)
The problem is that SQLite locks the database (file) for every read or write access to the database, whichs results in a, let's say, permanently locked database.
Then we switched to TMySQLCache. Seemed fine for a few minutes, but then MySQL had a problem with "Too many connections ...". Pretty much the same problem like with SQLite.
After that we used TAPCCache, but our cache size was too small, we had a cache-hit-ratio below 50%. APC was very busy writing into the cache and right afterwards deleting it
This caused a lot segmentation faults.
The solution was to raise the APC cache limit from 30 MB to 90 MB which resultet in a 99% cache-hit-ratio and no further problems.
IMHO, it's not possible to run a high traffic website with TOuputCache with anything other than a great enough byte-code or memory cache.
Anyone made the same experiences?
Best regards,
schmunk
