[TYPO3-performance] Problem with Database queries
Volker Lieder
support at its-lieder.de
Tue Apr 26 13:18:17 CEST 2011
Hi,
attached you find a "show full processlist" while the site is hanging.
Perhaps you can tell me whats happening inside of the db and what kind
of job/querie is locking all other requests.
Regards,
Volker Lieder
Am 26.04.11 13:05, schrieb Steffen Gebert:
>> 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.
>>
>> What do you need to help me within this issue?
>> I have some full processlists from mysql while the site is hanging, os
>> versions, typo3 versions...
> What tables are locked? Are they InnoDB or MyISAM?
>
> Kind regards
> Steffen
>
--
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.
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: db-queries.txt
URL: <http://lists.typo3.org/pipermail/typo3-performance/attachments/20110426/4fb5c32a/attachment-0001.txt>
More information about the TYPO3-performance
mailing list