NDO - why not innodb?

Hendrik Bäcker andurin at process-zero.de
Mon Aug 20 17:25:03 CEST 2007


Hi Kevin,

Kevin Menard wrote:
> 
> I'd highly recommend using InnoDB.  Actually, I'd recommend using
> PostgreSQL, but it's not my intention to start a flame war.  Given the
> critical nature of the data being logged, I'd ensure data consistency with
> InnoDB tables.
> 

Looking at my MySQL based NDO DB with 7000+ Service Checks I can see
tons of inserts every second.

I've only heard that PostgreSQL might be better in performance and for
this huge amount of data.

I also do not want a flame war too, but I would just like to know what
other people are thinking in the manner MySQL vs. PostgresQL.

Up to now I can say that the MySQL Process on my nagios server is eating
up the cpu's and I am thinking about to test it with a postgresql.

I am not a DB engenieer so please don't ask about my config params like
different kind of tunings ;)

Regards
Hendrik
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 2185 bytes
Desc: S/MIME Cryptographic Signature
URL: <https://www.monitoring-lists.org/archive/developers/attachments/20070820/52dddf2b/attachment.bin>
-------------- next part --------------
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
-------------- next part --------------
_______________________________________________
Nagios-devel mailing list
Nagios-devel at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-devel


More information about the Developers mailing list