[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