[TYPO3-dev] Fatal Query

[Dan Osipov]

Tried - in that case tt_news FE generation queries take significantly 
longer. I used the values in one of your presentations for InnoDB 
configuration setup (with slight variations).

Dan Osipov
Calkins Media
http://danosipov.com/blog/

Dmitry Dulepov wrote:
> Hi!
> 
> Dan Osipov wrote:
>> I truncated the list of categories - but there are many. Normally the
>> query runs fine, returning result in the thousands. But sometimes, the
>> query goes into "statistics" state, and locks the tt_news table. The
>> query hangs, preventing all other queries from exectuing, and requires a
>> manual restart of mySQL.
>>
>> I can hack tt_news module, but before I do - is there anything else
>> someone can recommend?
> 
> Switch tables to InnoDb. It will not lock.
>