[TYPO3-performance] Problem with Database queries

Björn Pedersen pedersen at frm2.tum.de
Tue Apr 26 12:59:23 CEST 2011


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



More information about the TYPO3-performance mailing list