[TYPO3-english] "DELETE FROM fe_sessions" job causes server to hang (Case 851)
steffen at steffen-gebert.de
Wed Feb 25 10:29:36 CET 2009
SÃ¸ren Madsen wrote:
> Every morning at 9AM it seems like TYPO3 instructs our database server
> to run a clean up job. We se lots of jobs like this one:
>> | 455212 | typo3 | ourserver.dk:36821 | typo3s | Query | 59 |
>> Locked | DELETE FROM fe_sessions
>> ses_id = 'b0ba76d6971a84a4455eeaf4916dd20b'
>> AND ses_nam
> The problem is that these jobs locks the server, and makes all of our
> sites unresponsive or they throw a database user denied error, and
> this takes 5-10 minutes.
Is fe_sessions table InnoDB or MyISAM? If MyISAM, switch to InnoDB.
More information about the TYPO3-english