[TYPO3-performance] Problem with Database queries

[Volker Lieder]

Hi Björn,

no, its no backup job, this we already checked and changed backupjob to 
run with --single-transaction.
The outages are in business ours were no backup is running.
We only have one database server at the moment, so every typo3 cronjob 
will also run against this db.

Regards,
Volker

Am 26.04.11 12:59, schrieb Björn Pedersen:
> Am 26.04.2011 10:14, schrieb Volker Lieder:
>> Hi List,
>>
>> i have a question from a typo3 customer.
>> As short description:
>>
>> 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.
>>
>
> Could that be some db backup kicking in with complete db lock  during
> the backup? (option -l /--lock-tables or  -x /--lock-all-tables/
> --first-slave  or
> --master-data (without --single-transaction)
>
> Or are you dumping also the cache tables? That could also take quite
> some time.
>
> Björn
>
> _______________________________________________
> 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.