[RFC] - NDOUtils duplicate lines problem

[Michael Friedrich]

shadih rahman wrote:
> I am using innodb.  I have worked with Hendrik's prescribed solution 
> on a very small installation of nagios and it appears to hold.
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

> I hope to do the bigger dump over weekend and hope for the best.  
> Thanks for all your help on this.
>
> On Wed, Mar 3, 2010 at 4:42 PM, Michael Friedrich 
> <michael.friedrich at univie.ac.at 
> <mailto:michael.friedrich at univie.ac.at>> wrote:
>
>     shadih rahman wrote:
>     > Michael,
>     >    Thanks for your responds.  Now if I upgrade to 1.4b9, would
>     that fix
>     > the problem for future queries.
>
>     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.
>
>     >     I can deal with existing data later.  Please advise on this.
>      Thanks
>
>     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?
>     --
>     DI (FH) Michael Friedrich
>     michael.friedrich at univie.ac.at <mailto:michael.friedrich at univie.ac.at>
>     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.
>     http://p.sf.net/sfu/intel-sw-dev
>     _______________________________________________
>     Nagios-devel mailing list
>     Nagios-devel at lists.sourceforge.net
>     <mailto:Nagios-devel at lists.sourceforge.net>
>     https://lists.sourceforge.net/lists/listinfo/nagios-devel
>
>
>
>
> -- 
> Cordially,
> Shadhin Rahman
>
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
> 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.
> http://p.sf.net/sfu/intel-sw-dev
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Nagios-devel mailing list
> Nagios-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-devel

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/developers/attachments/20100304/27f25efb/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
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.
http://p.sf.net/sfu/intel-sw-dev
-------------- next part --------------
_______________________________________________
Nagios-devel mailing list
Nagios-devel at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-devel