[TYPO3-english] "DELETE FROM fe_sessions" job causes server to hang (Case 851)
ries van Twisk
typo3 at rvt.dds.nl
Wed Feb 25 16:26:18 CET 2009
On Feb 25, 2009, at 4:10 AM, 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. We can't seem to find the origin of these
> jobs - can anyone help ? We obviously don't mind that these clean up
> jobs run, but we'd really like to know where they come from, and we'd
> really like to change the time they run.
> Kind regards,
> Søren Madsen
How big is the table fe_sessions and would adding a index help?
More information about the TYPO3-english