<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16809" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=106064614-19032009><FONT face=Arial size=2>Hi
Momo,</FONT></SPAN></DIV>
<DIV><SPAN class=106064614-19032009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=106064614-19032009><FONT face=Arial
size=2>> </FONT></SPAN>We are using Nagios 2.6 with NDOUtils 1.3.1.<SPAN
class=106064614-19032009><FONT face=Arial size=2> </FONT></SPAN></DIV>
<DIV><SPAN class=106064614-19032009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=106064614-19032009><FONT face=Arial size=2>I'm using Nagios
3.0.6 with ndo 1.4b7 but I had the same problem.</FONT></SPAN></DIV>
<DIV><SPAN class=106064614-19032009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=106064614-19032009><FONT face=Arial size=2>After installing
phpmyadmin it shows me several tips to increase the mysql
performance.</FONT></SPAN></DIV>
<DIV><SPAN class=106064614-19032009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=106064614-19032009><FONT face=Arial size=2>I've changed the
following entry's in my.cnf:</FONT></SPAN></DIV>
<DIV><SPAN class=106064614-19032009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=106064614-19032009><FONT face=Arial
size=2>key_buffer
=
4M<BR>key_buffer_size =
128M<BR>max_allowed_packet =
16M<BR>thread_stack =
128K<BR>thread_cache_size =
64<BR>table_cache =
512</FONT></SPAN></DIV>
<DIV><SPAN class=106064614-19032009></SPAN><SPAN class=106064614-19032009><FONT
face=Arial size=2>innodb_buffer_pool_size=1024M</FONT></SPAN></DIV>
<DIV><SPAN class=106064614-19032009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=106064614-19032009><FONT face=Arial size=2>I think the
innodb_buffer is the important thing because ndo table-type are always innodb in
NDO 1.4b7 I don't know if it is the same in 1.3.1!</FONT></SPAN></DIV>
<DIV><SPAN class=106064614-19032009><FONT face=Arial size=2>Be carefull and
read the MySQL documentation. After I did this configuration the memory usage of
mysql increased a lot.</DIV>
<DIV><BR></DIV></FONT></SPAN>
<DIV><FONT face=Arial size=2><SPAN class=106064614-19032009>> <FONT
face="Times New Roman" size=3> wasn't able to find any documentation on how the
table trimming job is triggered or scheduled, so if anybody knows how I could
schedule it to run by night, it would be greatly
appreciated.</FONT></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=106064614-19032009></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=106064614-19032009>The jobs can be
configured in ndo2db.cfg</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=106064614-19032009></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=106064614-19032009>Regards,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=106064614-19032009>Steffen</SPAN></FONT></DIV></BODY></HTML>