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

[Susanne Moog]

Hi,

Susanne Moog schrieb:
> Hi everyone,
> 
> we are experiencing some db performance problems. TYPO3 version is 4.2.5 
> with the last security fix manually patched.
> 
> Can someone give me a hint where and why those queries are generated 
> (and what I can do against it ;))
> 
> Additional info:
> OTHER: TYPO3_VERSION: 4.2.5 (patched)
> OTHER: PHP_VERSION  : 5.2.0-8+etch13
> MySQL: Client API version     5.0.32
> 

thank you all for your help, after twisting things a bit, it works 
again. Some general remarks for people having the same problems: What 
helped here most:

- Disable pconnect
- Look at slow_queries and fix those
-- use indexes where they make sense


And... if you have a second db server that isn't in use... use it (Ext: 
t3p_scalable) ;-).


Susanne