If we add a lot of messages to a queue (i.e. 500.000), and later when the messages has expired the database uses amost all of the CPU. In MySql administrator we can see that the database is busy with a sql like this: DELETE FROM JBM_MSG WHERE TIMESTAMP < 1194882127401 AND NOT EXISTS (SELECT * FROM JBM_MSG_REF WHERE JBM_MSG_REF.MESSAGE_ID = JBM_MSG.MESSAGE_ID).
There is no listener connected so all messages expires and no other software is connected to the database or to JBoss. How can we resolve this? We are using: JBoss application server 4.2.0 with JBoss Messaging 1.4.0 and MySQL 5.0.37 View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4104533#4104533 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4104533 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
