[TYPO3-performance] Problem with Database queries

[Volker Lieder]

Hi,

we implemented a mysql replication for the customer, and he changed his 
select queries from cronjobs and backendscripts to run against the 
slave. So we have less selects on the master.

Thank you for the hint with mysql-monitor, i keep that in mind for the 
next issues ;-)

Regards,
Volker

Am 25.05.11 20:56, schrieb 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
>>
>
> _______________________________________________
> TYPO3-performance mailing list
> TYPO3-performance at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-performance

-- 
Mit freundlichen Grüßen/Best regards
Volker Lieder
System Administrator

mail volker at its-lieder.de

ITS-Lieder
Kleinlindenerstrasse 3
35398 Giessen / Germany
http://www.its-lieder.de

UST-ID: DE260836372

==========================================================

Jegliche Stellungnahmen und Meinungen dieser E-Mail sind
alleine die des Autors und nicht notwendigerweise die der
Firma. Falls erforderlich, können Sie eine gesonderte
schriftliche Bestätigung anfordern.

Any views or opinions presented in this email are solely
those of the author and do not necessarily represent those
of the company. If verification is required please request
a hard-copy version.