On Fri, 28 May 2004 10:18:07 +0200
"Schroeder, Alexander" <alexander.schroeder@xxxxxxx> wrote:
> Hello Andre,
>
> > My MAXLOCKS parameter is currently 2680.
> >
> > How can I find out a good value for MAXLOCKS?
>
> Usually more by experiment. Unfortunately, this is a *GLOBAL* parameter, not
> per table or something. A too small value will possibly lead into deadlock, a
> too large value may be a waste of memory and slows things down.
> Actually, 2680 may be a little bit low.
>
> E.g. in R/3 systems values of 50000 - 150000 are quite normal.
>
Ok I will increase the value.
> >
> > Is the Dump I sent you really a classical deadlock situation?
> >
>
> Not classical by means of the internal deadlock detection, if you wanted
> to say this. It is either an escalation, or, as Elke wrote
> (hopefully not) a table lock issued by a LOCK TABLE statement.
>
> There are also way too much tab share locks that are already established
> in your dump.
>
Did I understand you correctly?
- If we do not use explicit LOCK TABLE statements in Transactionlevel 1 (=10)
tab_share locks can only be produced by a LOCK ESCALATION situation?
- How can I get Information how automatic DEADLOCK DETECTION works?
- It is a deadlock, because both sessions wait for a Lock that the other
session already owns? (That is how I read the Dump)
Thank you very much for your help.
Greetings, Andre'
>
> Regards
> Alexander Schröder
--
__________________________________________________________________________
Als Technologieunternehmen konzipieren und entwickeln wir maßgeschneiderte
Feedback- und
Monitoring-Systeme - wie beispielsweise Lösungen für Beschwerde- und
Ideenmanagement.
Mit dem Inquery® Survey Server bieten wir eine der leistungsfähigsten
Standardlösungen für
Online-Umfragen mit dem Schwerpunkt auf der Messung von Kundenzufriedenheit an.
__________________________________________________________________________
Inworks GmbH
Andre Reitz, Leiter Entwicklung
Hörvelsinger Weg 39, 89081 Ulm, Germany
Tel +49 (0) 731 / 93807-21
Fax +49(0)731/93807-18
Internet: http://www.inworks.de
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx
|
