[TYPO3-dev] DB Performance Problems (fe_sessions table)

[Susanne Moog]

Peter Russ schrieb:
> --- Original Nachricht ---
> Absender:   Susanne Moog
> Datum:       04.03.2009 14:44:
>> Hi everyone,
>>
>> we are experiencing some db performance problems. TYPO3 version is 
>> 4.2.5 with the last security fix manually patched.
>>
>> MySQL log shows thousands of the following queries:
>>
>> DELETE FROM fe_sessions    WHERE    ses_id = 
>> '9dd6ed3c54bdf13ea23cb82a7c095831'    AND ses_name = 'fe_typo_user'
>> DELETE FROM fe_sessions    WHERE    ses_id = 
>> 'bcabb26007a597827d5735e2d4d34f83'    AND ses_name = 'fe_typo_user'
>> DELETE FROM fe_sessions    WHERE    ses_id = 
>> 'bcabb26007a597827d5735e2d4d34f83'    AND ses_name = 'fe_typo_user'
>> DELETE FROM fe_sessions    WHERE    ses_id = 
>> '933e504f3b38d3cbe49839873d05a8aa'    AND ses_name = 'fe_typo_user'
>>
> 
> Why do you enable MySQl log on that low level on a production system?
> 

Hi Peter,

I don't. It was activated for approximately 5 minutes just to get a 
glimpse what's happening.

Regards,

Susanne