 | | | MaxDB turning very slow while executing big transactions | MaxDB turning very slow while executing big transactions 2007-04-26 - By Kittel, Martin
Back
Hi Stefano,
try upgrading to 7.5.00.44. This release fixes a performance issue when doing
many inserts/updates which involve LOBs. You should also check the system table
DOMAIN.LOCK_HOLDERS while your transaction is running to see if it holding many
locks. In that case it may be advisable to explicitly lock your table during
your transaction.
Best wishes,
Martin.
Martin Kittel
Development Manager
MaxDB&liveCache
SAP AG
Rosenthaler Str. 30
10178 Berlin
T +49 30 41092-332
F +49 30 41092-419
mailto:martin.kittel@(protected)
www.sap.com
Sitz der Gesellschaft/Registered Office: Walldorf, Germany
Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), L?o Apotheker,
Werner Brandt, Claus Heinrich, Gerhard Oswald, Peter Zencke
Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso
Plattner
Registergericht/Commercial Register Mannheim No HRB 350269
Diese E-Mail kann Betriebs- oder Gesch?ftsgeheimnisse oder sonstige
vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrt?mlich
erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielf?ltigung
oder Weitergabe der E-Mail ausdr?cklich untersagt.
Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen
Dank.
This e-mail may contain trade secrets or privileged, undisclosed, or otherwise
confidential information. If you have received this e-mail in error, you are
hereby notified that any review, copying, or distribution of it is strictly
prohibited. Please inform us immediately and destroy the original transmittal.
Thank you for your cooperation.
>-- --Original Message-- --
>From: Stefano Ghezzi [mailto:stefano.ghezzi@(protected)]
>Sent: Mittwoch, 25. April 2007 09:11
>To: maxdb@(protected)
>Subject: [LIKELY JUNK]MaxDB turning very slow while executing
>big transactions
>
>I've a very big transaction which involves one thousand
>of insert before commiting everything
>
>At a certain point during the transaction MaxDB
>starts to slow down everything and inserts
>are processed in a very long time
>
>At the beginning they run in tens of milliseconds, after some
>hundreds of inserts they run in tens of seconds and insert
>time keep increasing
>
>I see also a kernel process running at 100% cpu and
>system with a very high wait on IO.
>
>
>It seems to me that this could be related to some
>kernel configuration parameter to manage transaction
>that i need to extend
>
>Any idea?
>
>Thanks in advance
>
>PS: MaxDB 7.5.0.19
>
>--
>__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ __
>Stefano Ghezzi ICTeam S.p.A
>tel 035 4232129 fax 035 4522034
>email stefano.ghezzi@(protected) url http://www.icteam.com
>mobile 335 7308587 skype:stefanoghezzi?chat
>__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ __
>
>
>--
>MaxDB Discussion Mailing List
>For list archives: http://lists.mysql.com/maxdb
>To unsubscribe:
>http://lists.mysql.com/maxdb?unsub=martin.kittel@(protected)
>
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=mysql@(protected)
|
|
|