<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> </head> <body bgcolor="#ffffff" text="#000099"> 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?<br> <pre class="moz-signature" cols="72">-- A. Davis Email: <a class="moz-txt-link-abbreviated" href="mailto:nccomp@gmail.com">nccomp@gmail.com</a> "There is no limit to what a man can accomplish if he doesn't care who gets the credit." - Ronald Reagan </pre> </body> </html>