<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#ffffff" text="#000000"> <tt>shadih rahman wrote:</tt> <blockquote cite="mid:6db4a4201003032107tcbb08dex71610b6631be47c5@mail.gmail.com" type="cite"><tt>I am using innodb. I have worked with Hendrik's prescribed solution on a very small installation of nagios and it appears to hold. </tt></blockquote> <tt>Hm. Could you post 2 rows before and the merged one afterwards (clean sensitive information). I want to check if data is consistent because i don't believe that replace into does the same like insert .. on duplicate key update ... Of course offlist too, if you like to. Kind regards, Michael </tt> <blockquote cite="mid:6db4a4201003032107tcbb08dex71610b6631be47c5@mail.gmail.com" type="cite"><tt> I hope to do the bigger dump over weekend and hope for the best. Thanks for all your help on this. </tt> <div class="gmail_quote"><tt>On Wed, Mar 3, 2010 at 4:42 PM, Michael Friedrich <<a moz-do-not-send="true" href="mailto:michael.friedrich@univie.ac.at">michael.friedrich@univie.ac.at</a>> wrote: </tt> <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <div class="im"><tt>shadih rahman wrote: > Michael, > Thanks for your responds. Now if I upgrade to 1.4b9, would that fix > the problem for future queries. </tt> </div> <tt>Looking at CVS head there is no such fix applied. but you define those unique keys yourself anyways - just small parts to do and already mentioned in a post some while ago by hendrik. </tt> <div class="im"><tt> > I can deal with existing data later. Please advise on this. Thanks </tt> </div> <tt>46 gb is a bunch of data. and that within mysql. are you using myisam or innodb? and did you think about moving to postgres/oracle? -- </tt> <div> <div class="h5"><tt>DI (FH) Michael Friedrich <a moz-do-not-send="true" href="mailto:michael.friedrich@univie.ac.at">michael.friedrich@univie.ac.at</a> Tel: +43 1 4277 14359 Vienna University Computer Center Universitaetsstrasse 7 A-1010 Vienna, Austria ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. <a moz-do-not-send="true" href="http://p.sf.net/sfu/intel-sw-dev" target="_blank">http://p.sf.net/sfu/intel-sw-dev</a> _______________________________________________ Nagios-devel mailing list <a moz-do-not-send="true" href="mailto:Nagios-devel@lists.sourceforge.net">Nagios-devel@lists.sourceforge.net</a> <a moz-do-not-send="true" href="https://lists.sourceforge.net/lists/listinfo/nagios-devel" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagios-devel</a> </tt> </div> </div> </blockquote> </div> <tt> -- Cordially, Shadhin Rahman </tt> <pre wrap=""><tt> </tt><hr size="4" width="90%"><tt> ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. <a class="moz-txt-link-freetext" href="http://p.sf.net/sfu/intel-sw-dev">http://p.sf.net/sfu/intel-sw-dev</a></tt></pre> <pre wrap=""><tt> </tt><hr size="4" width="90%"><tt> _______________________________________________ Nagios-devel mailing list <a class="moz-txt-link-abbreviated" href="mailto:Nagios-devel@lists.sourceforge.net">Nagios-devel@lists.sourceforge.net</a> <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/nagios-devel">https://lists.sourceforge.net/lists/listinfo/nagios-devel</a> </tt></pre> </blockquote> <tt> </tt> </body> </html>