Concise list of best overall performance tweaks

[Andrew Davis]

If running the latest version(s) of Nagios and the plugins, using mysql, 
and gathering trending info, is there a list available of the best 
performance tweaks one can make? I seem to read a lot that mySQL is a 
resource whore when also on the Nagios server. Some have commented on 
seeing significant increases when moving it elsewhere. Others have 
mentioned adding lines like "innodb_flush_log_at_trx_commit = 2" into 
the mysql config file, while others have also mentioned database 
indexes, etc. Of course, for non-DBA's, knowing which databases to 
create indexes on (or how to do it without mucking it up) are up for 
debate. Log file rotation is always a good one, but this seems to be 
built into Nagios 3.x, though I've read of people running Cacti on their 
Nagios server as well and Cacti has no default log rotation. So... 
perhaps everyone could include the steps they took to resolve various 
performance issues... perhaps also including the actual steps taken (ie: 
if making indexes, which ones and why) and we can cull them into the 
Nagios wiki on NagiosExchange?

-- 


  A. Davis
  Email:     nccomp at gmail.com

  "There is no limit to what a man can accomplish
   if he doesn't care who gets the credit." - Ronald Reagan

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20090514/202fe334/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image 
processing features enabled. http://p.sf.net/sfu/kodak-com
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
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