Actions
Bug #99589
closed
Huge amount of records in cache_hash table with maximum lifetime
Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Caching
Target version:
-
Start date:
2023-01-18
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
10
PHP Version:
7.4
Tags:
caching, typo3databasebackend
Complexity:
Is Regression:
Sprint Focus:
Description
I noticed that cache_hash table contains massive amount of records with lifetime 2145909600. The table „cache_hash“ itself had a size of 241 GB and these records can not be removed by Table garbage collection (scheduler) because the mentioned lifetime.
As I can see Typo3DatabaseBackend contains constant which is called FAKED_UNLIMITED_EXPIRE with value 2145909600. It seems that unlimited expire value is used for some caching entries if provided lifetime param is 0. These entries contain following tags: ident_TMPL_CONDITIONS_ALL , ident_TS_TEMPLATE.
Updated by
Actions