This is a multi-part message in MIME format.
--------------080700010902050103020302
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
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: [email protected]
> 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
> [email protected]
> https://lists.sourceforge.net/lists/lis ... gios-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 [email protected]
__________________________________________________
--------------080700010902050103020302
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
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: [email protected]
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
[email protected]
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.n
...[email truncated]...
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]