[TYPO3-english] huge Realurl and cache db tables!!!

Dmitry Dulepov dmitry at typo3.org
Wed Jan 28 16:50:53 CET 2009


Hi!

stefano cecere wrote:
> i was just wondering if it's normal that realurl has so many big tables
> (for a medium size website):
> 
> tx_realurl_chashcache 276,825 rows - 26Mb
> tx_realurl_urlencodecache 15.000 rows - 12Mb

Hard to say. It depends a lot on the extensions you have. For example, if you have cal, there will be huge number of links in for cal in both tables.

> then there is cache_hash that is taking 34Mb for just 1136 rows (it
> takes 12,304bytes per row, even for a few chars, since it has mediumblob
> in it,)!

Almost every extension adds data to this table. See [1] if you are interested in PHP details.

> does anybody know if the new caching system of 4.3 will light all this?

No, it will not.

[1] http://typo3bloke.net/post-details/why_substitutemarkerarraycached_is_bad/

-- 
Dmitry Dulepov
TYPO3 core team
"Sometimes they go bad. No one knows why" (Cameron, TSCC, "Dungeons&Dragons")


More information about the TYPO3-english mailing list