Master is fine, no optimisations have been done on the database as its a shared server with many other apps on it, so is pretty much a default configuration. Heres the output from a "top" top - 16:44:33 up 82 days, 17:52, 1 user, load average: 2.74, 2.97, 3.23 Tasks: 311 total, 3 running, 308 sleeping, 0 stopped, 0 zombie Cpu0 : 6.9%us, 3.2%sy, 0.0%ni, 89.5%id, 0.1%wa, 0.0%hi, 0.2%si, 0.0%st Cpu1 : 3.2%us, 1.0%sy, 0.0%ni, 95.7%id, 0.1%wa, 0.0%hi, 0.0%si, 0.0%st Cpu2 : 7.0%us, 2.1%sy, 0.0%ni, 90.3%id, 0.5%wa, 0.0%hi, 0.0%si, 0.0%st Cpu3 : 17.0%us, 1.9%sy, 0.0%ni, 80.9%id, 0.3%wa, 0.0%hi, 0.0%si, 0.0%st Cpu4 : 4.8%us, 2.5%sy, 0.0%ni, 91.6%id, 1.1%wa, 0.0%hi, 0.0%si, 0.0%st Cpu5 : 4.1%us, 1.3%sy, 0.0%ni, 94.4%id, 0.1%wa, 0.0%hi, 0.0%si, 0.0%st Cpu6 : 11.7%us, 2.6%sy, 0.0%ni, 85.5%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st Cpu7 : 8.4%us, 2.1%sy, 0.0%ni, 89.4%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 4049164k total, 3095420k used, 953744k free, 142184k buffers Swap: 8393920k total, 55284k used, 8338636k free, 996756k cached
I think that the real answer it to get onto newer Opsview Code, which if you have seen my last response I have now been able to re-open negotiations over the OS for the platform. Thanks again David _____ From: [email protected] [mailto:[email protected]] On Behalf Of Rafael Luis Carneiro Sent: 09 July 2009 16:49 To: Opsview Users Subject: Re: [opsview-users] Hostgroup Caching ? I'm not sure if your problem is on the DB end or the master itself. What is the load like on the master? Have you tried any of the optimizations on the DB: http://docs.opsview.org/doku.php?id=opsview3.1:mysql#mysql_tuning <http://docs.opsview.org/doku.php?id=opsview3.1:mysql#mysql_tuning> That helped me, but not too much. I remember that what really helped was the thread_cache_size (i'm using 40). What version of Opsivew are you running? I remember that the upgrate to 3.0.4 (or 3.0.3) helped a lot as well. Raf On Thu, Jul 9, 2009 at 11:24 AM, Ton Voon <[email protected] <mailto:[email protected]> > wrote: Hi David, On 9 Jul 2009, at 16:12, David Bell wrote: Thanks for the response Raf. Yes the Nagios cgi pages are correct - I assume that is because its reading that info from files. My opsviewd.log does have a few import issues that seem to co-incide with when we see problems - I am concerned about the one at the top of this list [2009/07/08 17:44:54] [import_ndologsd] [WARN] Import of 1247068819470548, size=35240212, took 2674.88318109512 seconds > 5 seconds [2009/07/08 17:45:02] [import_ndologsd] [WARN] Import of 1247068821483999, size=86727, took 8.11954402923584 seconds > 5 seconds [2009/07/08 17:45:34] [import_ndologsd] [WARN] Import of 1247068834758987, size=2306127, took 28.0002701282501 seconds > 5 seconds [2009/07/08 17:45:51] [import_ndologsd] [WARN] Import of 1247068844539990, size=1401907, took 16.6511950492859 seconds > 5 seconds [2009/07/08 17:46:07] [import_ndologsd] [WARN] Import of 1247068852496928, size=1386952, took 16.3429758548737 seconds > 5 seconds [2009/07/08 17:46:32] [import_ndologsd] [WARN] Import of 1247068863620525, size=2233089, took 25.1329939365387 seconds > 5 seconds [2009/07/08 17:46:45] [import_ndologsd] [WARN] Import of 1247068871060241, size=1083300, took 13.0434839725494 seconds > 5 seconds [2009/07/08 17:47:10] [import_ndologsd] [WARN] Import of 1247068949423567, size=537320, took 6.85540199279785 seconds > 5 seconds [2009/07/08 17:52:54] [import_ndologsd] [WARN] Import of 1247070234375124, size=100348, took 5.26332020759583 seconds > 5 seconds We are using a remote server for the mySQL database which is of a very high spec, hardware is Sun, it has 16GB of RAM etc, so I dont think the database server is the issue - so although we dont have the innodb optimisations on it (it hosts a few databases) I dont think this is the problem. I am currently thinking that it may be a network issue between the Master and the Database server - is this likely? What sub version of Opsview are you on? In 2.12.9, we did some big improvements to the import time for large scale systems, which have carried over to the current versions. You really need to upgrade to see these benefits though. Ton _______________________________________________ Opsview-users mailing list [email protected] <mailto:[email protected]> http://lists.opsview.org/lists/listinfo/opsview-users <http://lists.opsview.org/lists/listinfo/opsview-users> ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
