[TYPO3-dev] innoDB filesize nightmare

Steffen Kamper steffen at sk-typo3.de
Mon Oct 1 13:42:56 CEST 2007


"Dmitry Dulepov [typo3]" <dmitry at typo3.org> schrieb im Newsbeitrag 
news:mailman.1.1191071691.17549.typo3-dev at lists.netfielders.de...
> Hi!
>
> Steffen Kamper wrote:
>> i was very astonished looking at the filesizes of file ibdata1 in 
>> mysql-dir.
>> I have a "fresh" Rootserver with 2 TYPO3-productive sites. After 5 days i 
>> had 7.5 GB innoDB-data.
>> MySQL stopped because the size was limited to 2GB. No i increased to 4GB. 
>> I really had to investigate whats going on.
>
> This is a bit strange. I have several large sites on one server but all 
> databases fits fine into three innodb files 2x4gb + 1x2gb.
>

i know why: i have cal on all pages (miniview and list as teasers) and the 
sites are heavy visited by se-bots. I can observe the high increase ;)
I'm experimenting now with cache_period parameter

vg  Steffen

> -- 
> Dmitry Dulepov
> TYPO3 freelancer / TYPO3 core team member
> Web: http://typo3bloke.net/
> Skype: callto:liels_bugs 






More information about the TYPO3-dev mailing list