JON console responding very slow after upgrade.
Issue
- We have upgraded Jboss Operation Network from 2.3 to 2.4 , since then the console is responding very slow while loading pages.
- We enabled database tracing and found long response times for certain queries (below).
INSERT INTO RHQ_MEASUREMENT_DATA_NUM_1H (SELECT :1 , ft.schedule_id, AVG(value), MIN(value), MAX(value)FROM RHQ_MEAS_DATA_NUM_R13 ft WHERE ft.time_stamp >= :2 AND ft.time_stamp < :3 GROUP BY ft.schedule_id) INSERT INTO RHQ_MEASUREMENT_BLINE ( id, BL_MIN, BL_MAX, BL_MEAN,BL_COMPUTE_TIME, SCHEDULE_ID )SELECT RHQ_MEASUREMENT_BLINE_ID_SEQ.nextval, blMin, blMax, blAvg, coTime, schId FROM ( SELECT MIN(data1h.minvalue) AS blMin,MAX(data1h.maxvalue) AS blMax,AVG(data1h.value) AS blAvg, :1 as coTime, data1h.SCHEDULE_ID as schId FROM RHQ_MEASUREMENT_DATA_NUM_1H data1h INNER JOIN RHQ_MEASUREMENT_SCHED sched ON data1h.SCHEDULE_ID = sched.id INNER JOIN RHQ_MEASUREMENT_DEF def ON sched.definition = def.id LEFT OUTER JOIN RHQ_MEASUREMENT_BLINE bline ON sched.id = bline.SCHEDULE_ID WHERE ( def.numeric_type = 0 ) AND ( bline.id IS NULL ) AND ( data1h.TIME_STAMP BETWEEN :2 AND :3 ) AND ROWNUM < 100001 GROUP BY data1h.SCHEDULE_ID HAVING data1h.SCHEDULE_ID in ( SELECT distinct (mdata.SCHEDULE_ID) FROM RHQ_MEASUREMENT_DATA_NUM_1H mdata WHERE mdata.TIME_STAMP <= :4 ) ) INSERT INTO RHQ_MEASUREMENT_DATA_NUM_6H (SELECT :1 , ft.schedule_id, AVG(value), MIN(minvalue), MAX(maxvalue)FROM RHQ_MEASUREMENT_DATA_NUM_1H ft WHERE ft.time_stamp >= :2 AND ft.time_stamp < :3 GROUP BY ft.schedule_id) DELETE FROM rhq_measurement_data_trait WHERE EXISTS (SELECT t2.schedule_id, t2.time_stamp FROM rhq_measurement_data_trait t2,(SELECT max(t4.time_stamp) as mx, t4.schedule_id as schedule_id FROM rhq_measurement_data_trait t4 WHERE t4.time_stamp < :1 GROUP BY t4.schedule_id) t3 WHERE t2.schedule_id = t3.schedule_id AND t2.time_stamp < t3.mx AND rhq_measurement_data_trait.time_stamp = t2.time_stamp AND rhq_measurement_data_trait.schedule_id = t2.schedule_id)
- How can we improve performance in the GUI?
Environment
- JBoss Operations Network(JON) 2.4.0
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.