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

[Peter Russ]

--- 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?

Peter

-- 
Fiat lux! Docendo discimus.
_____________________________
uon GbR

http://www.uon.li
http://www.xing.com/profile/Peter_Russ