Nagios Support Forum

This is a multi-part message in MIME format.
--------------060106010408070204000208
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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
> > 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
> [email protected]
> 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
> [email protected]
>
> https://lists.sourceforge.net/lists/lis ... gios-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
> [email protected]
> https://lists.sourceforge.net/lists/lis ... gios-devel


--------------060106010408070204000208
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit







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


<blockquote
cite="mid:6db4a4201003032107tcbb08dex71610b6631be47c5@

...[email truncated]...


This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]