<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
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.<br>
<br>
[]s. <br>
<br>
Ethan Galstad wrote:
<blockquote cite="mid:46C35DDA.40003@nagios.org" type="cite">
<pre wrap="">Alessandro Ren wrote:
</pre>
<blockquote type="cite">
<pre wrap=""> 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.
</pre>
</blockquote>
<pre wrap=""><!---->
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: <a class="moz-txt-link-abbreviated" href="mailto:nagios@nagios.org">nagios@nagios.org</a>
Website: <a class="moz-txt-link-freetext" href="http://www.nagios.org">http://www.nagios.org</a>
-------------------------------------------------------------------------
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 >> <a class="moz-txt-link-freetext" href="http://get.splunk.com/">http://get.splunk.com/</a>
_______________________________________________
Nagios-devel mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Nagios-devel@lists.sourceforge.net">Nagios-devel@lists.sourceforge.net</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/nagios-devel">https://lists.sourceforge.net/lists/listinfo/nagios-devel</a>
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<title>OpSign</title>
<font color="#3366ff">__________________________________________________</font><br>
<table border="0" cellpadding="0" cellspacing="0" width="350">
<tbody>
<tr>
<td valign="top" width="130"> <font color="#000080"
face="Helvetica, Arial, sans-serif" size="-1"><b>Alessandro Ren</b></font><br>
</td>
<td valign="top" width="220"> <font color="#000080"
face="Helvetica, Arial, sans-serif" size="-1"><i><b>OpServices</b></i></font><br>
<font color="#808080" face="Helvetica, Arial, sans-serif"
size="-1"><i><b>Luciana de Abreu, 471 - Sala 403</b></i></font><br>
<font color="#808080" face="Helvetica, Arial, sans-serif"
size="-1"><i><b>Porto Alegre, RS - CEP 90570-060</b></i></font><br>
</td>
</tr>
</tbody>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="350">
<tbody>
<tr>
<td valign="middle" width="180"> <font color="#000000"
face="Wingdings" size="-3"><b>(</b></font><font color="#999999"
face="Helvetica, Arial, sans-serif" size="-3"> phone 55(51)3061-3588</font><br>
<font color="#000000" face="Wingdings" size="-3"><b>4</b></font><font
color="#999999" face="Helvetica, Arial, sans-serif" size="-3"> fax 55(51)3061-3588</font><br>
</td>
<td valign="middle" width="200"> <font color="#000000"
face="Wingdings" size="-3"><b>Q</b></font><font color="#999999"
face="Helvetica, Arial, sans-serif" size="-3"> mobile 55(48)9987-0625</font><br>
<font color="#000000" face="Wingdings" size="-3"><b>:</b></font><font
color="#999999" face="Helvetica, Arial, sans-serif" size="-3"> email <a
href="mailto:%22alessandro.ren@opservices.com.br%22">alessandro.ren@opservices.com.br</a></font><br>
</td>
</tr>
</tbody>
</table>
<font color="#3366ff">__________________________________________________</font><br>
</div>
</body>
</html>