Re: [LIKELY JUNK]MaxDB turning very slow while executing big transactions
Stefano Ghezzi <[email protected]> Sat, 28 Apr 2007 10:17:57 +0200
| Newsgroups | gmane.comp.db.maxdb |
|---|---|
| Message-ID | <[email protected]> |
Il works with 7.5.0.44 thanks!! bye Kittel, Martin ha scritto: > 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:[email 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:[email protected]] >> Sent: Mittwoch, 25. April 2007 09:11 >> To: [email 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 [email 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/[email protected] >> >> >> -- ____________________________________________________________ Stefano Ghezzi ICTeam S.p.A tel 035 4232129 fax 035 4522034 email [email 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/[email protected]