Yes. I have the same feeling.. In our setup we have 14 masters dumping data into a central ODW, We have a diffrent issue. AFAIK , after dumping the servicechecks and other tables, it writes in dataloads that the odw import is success. Then it goes on for cleaning up the service_saved_state . But since we have 14 imports happening at more or less same time and multiple delete query on service_saved_states, some of them fails due to "lock wait timeout". But this doesnot create a problem for the next import as the dataloads is marked as success.But this can cause next import to take more time...
This is just a WILD GUESS !!!! -Magin George. On Mon, Jan 18, 2010 at 6:33 PM, Kang <[email protected]> wrote: > Hello. > > https://secure.opsera.com/jira/browse/OPS-950 > > I'm using Opsview v 3.3.2 now. > but i think there is no service_saved_state table(in our DB, its size is > 220MB) growing problem. > ( i executed the DELETE query which you pasted but there is no change in > table data length size. ) > i doubt it is the main cause of performance degradation. > les > > s 2010/1/18 Ton Voon <[email protected]> > > Hi! >> >> Just wanted to make people aware of a fix for reducing the time to run >> import_runtime. This affects people if there are importing into ODW and have >> a large number of services. >> >> The cleanup section wasn't getting invoked correctly which means that the >> odw.service_saved_state table will continue to grow and it may slow down the >> duration of the hourly imports into ODW. >> >> You can run this SQL command on your ODW database if you find that the >> odw.service_saved_state table is too large: >> >> mysql> DELETE FROM service_saved_state WHERE opsview_instance_id = 1 AND >> start_timev <= UNIX_TIMESTAMP(NOW() - INTERVAL 7 DAY) >> >> The patch is here: >> >> >> https://secure.opsera.com/wsvn/wsvn/opsview/trunk/opsview-core/bin/import_runtime?op=diff&; >> >> This will be included in a future release. >> >> 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 > >
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
