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 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]> 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] > http://lists.opsview.org/lists/listinfo/opsview-users > >
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
