NDO - why not innodb?

Alessandro Ren alessandro.ren at opservices.com.br
Mon Aug 20 15:51:08 CEST 2007


    We have switched to innodb and have had some perfomance 
improvements. I think the main reason would be table lock vs register 
lock, as the myisam has to lock the whole table to make a insert or update.

    []s.   

Ethan Galstad 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.
>
>
> Ethan Galstad,
> Nagios Developer
> ---
> Email: nagios at nagios.org
> Website: http://www.nagios.org
>
> -------------------------------------------------------------------------
> 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/
> _______________________________________________
> Nagios-devel mailing list
> Nagios-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-devel
>   

-- 
__________________________________________________
*Alessandro Ren*
	/*OpServices*/
/*Luciana de Abreu, 471 - Sala 403*/
/*Porto Alegre, RS - CEP 90570-060*/

*(*   phone 55(51)3061-3588
*4*    fax 55(51)3061-3588
	*Q*   mobile 55(48)9987-0625
*:*   email alessandro.ren at opservices.com.br 
<mailto:%22alessandro.ren at opservices.com.br%22>

__________________________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/developers/attachments/20070820/5b0ab249/attachment.html>
-------------- 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