[TYPO3-performance] Problem with Database queries

Georg Kuehnberger georg at georg.org
Wed Jun 15 21:05:36 CEST 2011


On 30.05.2011 09:58, Volker Lieder wrote:
> Hi,
>
> there seem to running some other queries which block the website.
> I attached two full process lists from the mysql server when the site is
> hanging.
> Perhaps someone can have a look on it.

did so;
your problem seems rather to be phpbb, than TYPO3.
regards g


>
> Regards,
> Volker Lieder
>
> Am 03.05.11 12:03, schrieb Volker Lieder:
>> 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
>>
>



More information about the TYPO3-performance mailing list