2009/3/17 Toussaint OTTAVI <[email protected]>:
> Then, I'll investigate further how NDO and MySQL work... And, maybe, I'll
> offer a new server with decent performance to my Nagios (in replacement of
> the good old hp Proliant of 8 years old...)
Marc DeTrano from Gridshield recently contributed an excellent
solution to the slow startup problem which I summarised like so:
I simply added a file "nagios.cnf"
under /etc/mysql/conf.d like so:
[mysqld]
innodb_flush_log_at_trx_commit = 2
and it reduced my Nagios startup time from more than 3 minutes to only
30 seconds!
Note that this change can mean you might lose a second or two of data
in the event of a database crash, but for me that's no problem.
A few other solutions have been discussed in this email list recently
including adding indexes and limiting the amount of data held. It
would probably benefit you to do a search for MySQL in the email list
archives.
Cheers,
Jim
------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Nagios-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting
any issue.
::: Messages without supporting info will risk being sent to /dev/null
