[TYPO3-english] "DELETE FROM fe_sessions" job causes server to hang (Case 851)

[Steffen Gebert]

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
>>      WHERE
>>      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.

Steffen