[TYPO3-dev] problems with cache hashes

[ries van Twisk]

On Nov 28, 2007, at 9:13 AM, Dmitry Dulepov [typo3] wrote:

> Hi!
>
> ries van Twisk wrote:
>> As far as I know TYPO3 doesn't require InnoDB to be installed,
>> if so and there are problems in the area mentioned,
>> shouldn't TYPO3 not come with a proper solution? This
>> is what TYPO3 folks always has been doing.
>
> Yes, TYPO3 does not require InnoDb because many hosters still have  
> that disabled. But TYPO3 folks already changed engine type for those  
> tables to InnoDb and said in NEWS.txt that you are supposed to use  
> InnoDb for these tables if you want good performance :)

Sorry,
I did understood that this discussion was about problems with cache  
hashes and deadlocks, and not directly about performance (indirectly  
it is because of the locks)

>
>
>> TYPO3 should come with a requirement that MySQL needs to be installed
>> and InnoDB MUSt be enabled.
>
> Not everyone needs that. In any case you will get much better  
> performance with InnoDb & cache_* tables, so I assume major  
> companies already use that at least for the sake of database  
> stability. MyISAM crashes tables too often.

aren't deadlocks problematic and might accure even on smaller sites?

>
>
>> At least a warning should be issues during installation and/or in the
>> installed tool
>> that InnoDB is not used and thus caching will not work properly.
>
> It depends on what you call "work properly" ;) But I agree: the  
> warning should eb shown that InnoDb is not enabled and performance  
> may be compromized.

I call 'work properly' the opposite of 'doesn't work properly' :D

if TYPO3 can create dealocks in a database that is set to MyISAM then  
I don't think that typo3 doesn't do something properly, that is if we  
say TYPO3 needs MySQL + MyISAM
as a minimal requirement. I hope I express correctly, but we all know  
what I am saying.

>
>
>> But I don't think we cannot just ignore the issues we are having.
>
> I agree. May be Thomas can include this check in his new Setup module?
>
> -- 
> Dmitry Dulepov
> TYPO3 core team
> Web: http://typo3bloke.net/
> Skype: callto:liels_bugs
> _______________________________________________
> TYPO3-dev mailing list
> TYPO3-dev at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev

--
Ries van Twisk
Freelance TYPO3 Developer
email: ries at vantwisk.nl
web:   http://www.rvantwisk.nl/
skype: callto://r.vantwisk
Phone: + 1 810-476-4193