[TYPO3-performance] Problem with Database queries

[Georg Kuehnberger]

Volker,

Guess you solved the problem by now; would you care telling the group 
about the cause and solution?

regards Georg
PS: Having been you I would have used mysql-monitor for a min of 48h. 
see http://www.mysql.de/products/enterprise/monitor.html


On 03.05.2011 12:03, Volker Lieder wrote:
> Hi,
> thank you all for your responses, we try out the different settings and
> i write back the solution if there is one ;-)
> At the moment we analyse the mysql queries from customer related addons.
>
> So thank you all,
>
> Regards,
> Volker
>
> Am 03.05.11 07:05, schrieb Timo Bienk:
>> Hi Volker,
>>
>> maybe persistent connections?
>> Just check your localconf if persistent connections are disabled:
>>
>> $TYPO3_CONF_VARS['SYS']['no_pconnect'] = true;
>>
>> kind regards
>> Timo
>>
>>
>> Am 26.04.11 10:14, schrieb Volker Lieder:
>>> We use one dedicated webserver and one dedicated db server,
>>> both servers have multi cpus and cores and about 16GB ram, SAS Raids.
>>>
>>> Sometimes the website hangs while we see a loot of database queries
>>> which are locked by another process we cant identify.
>>>
>>> This is for round about 5 minutes and then the site works fine again.
>>
>> _______________________________________________
>> TYPO3-performance mailing list
>> TYPO3-performance at lists.typo3.org
>> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-performance
>