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