NDO - why not innodb?

[Kevin Menard]

On 8/15/07 4:11 PM, "Ethan Galstad" <nagios at nagios.org> wrote:

> Alessandro Ren wrote:
>>     I just would like to know the reason that the NDO DB uses myisam
>> engine and not Innodb. If it is because of performance issues?
>>     It seems to me that innodb would be better in the long run, having
>> huge databases, am I missing something?
>>     Thanks.
>> 
> 
> I just chose MyISAM because it was the default choice in my setup.
> Looking at the storage engine docs for MySQL, it might be beneficial to
> switch to InnoDB.  I would certainly welcome input from DB folks on this
> issue.

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.

-- 
Kevin Menard
Servprise International, Inc.
+1 508.892.3823 x308


-------------------------------------------------------------------------
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/