[TYPO3-dev] Fatal Query

[Dmitry Dulepov]

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.

-- 
Dmitry Dulepov
TYPO3 core team

Mr. Harris: People say that you were the last person to speak with Jordon...
            Is that true? 
Cameron: I don't know. Are you asking me if people say I was the last person
            to talk to Jordon? Or are you asking me if I was the last person
            to talk to her? 
Mr. Harris: I guess I'm asking if you were. 
Cameron: I don't know.