|
From: Simen A. S. <ssk...@no...> - 2004-04-30 09:23:07
|
Hello, I have a test environment running Hermes (ebms2) MSH v.pre-1.0.0.0. I have made a servlet using msh as part of an ordering system with a supplier. I could need some advice on how to better control the msh. When using the Servlet Heavily I encounter some serious performance issue with the mysql db ( I use mysql as a msh database ). The performance issue is due to some queries running from the msh like:=20 SELECT MessageStore.c_messageid, MessageInfo.c_conversationid, MessageStore.c_filename, MessageStore.c_sequencenumber FROM MessageStore, MessageInfo WHERE MessageStore.c_messageid=3DMessageInfo.c_messageid AND MessageStore.c_sequencenumber>=3D-9998 AND MessageStore.c_cpaid=3D'*' AND MessageStore.c_conversationid=3D'*' AND MessageStore.c_service=3D'*' AND MessageStore.c_action=3D'*' AND MessageStore.c_state>=3D-7 AND MessageStore.c_state<=3D-5 Looking in to msh.log I see loads of this: 2004-04-30 11:03:18,165 INFO [http8080-Processor2]: Process command: Get= message (32) 2004-04-30 11:03:18,166 DEBUG [http8080-Processor2]: =3D> MessageServiceH= andler.processCommand 2004-04-30 11:03:18,166 DEBUG [http8080-Processor2]: =3D> MessageServiceH= andler.getMessage 2004-04-30 11:03:18,166 DEBUG [http8080-Processor2]: =3D> MessageServiceH= andler.getNextUndeliveredMessage 2004-04-30 11:03:18,167 DEBUG [http8080-Processor2]: =3D> MessageServer.g= etUndeliveredMessages 2004-04-30 11:03:18,167 DEBUG [http8080-Processor2]: =3D> DbConnectionPoo= l.getConnection 2004-04-30 11:03:18,167 DEBUG [http8080-Processor2]: <=3D DbConnectionPoo= l.getConnection 2004-04-30 11:03:18,196 DEBUG [http8080-Processor2]: <=3D MessageServer.g= etUndeliveredMessages 2004-04-30 11:03:18,196 DEBUG [http8080-Processor2]: <=3D MessageServiceH= andler.getNextUndeliveredMessage with no message 2004-04-30 11:03:18,196 DEBUG [http8080-Processor2]: =3D> Transaction.com= mit (txID: #1530) 2004-04-30 11:03:18,197 DEBUG [http8080-Processor2]: =3D> DbConnectionPoo= l.freeConnection 2004-04-30 11:03:18,197 DEBUG [http8080-Processor2]: <=3D DbConnectionPoo= l.freeConnection 2004-04-30 11:03:18,197 DEBUG [http8080-Processor2]: <=3D Transaction.com= mit 2004-04-30 11:03:18,198 DEBUG [http8080-Processor2]: <=3D MessageServiceH= andler.getMessage 2004-04-30 11:03:18,198 DEBUG [http8080-Processor2]: <=3D MessageServiceH= andler.processCommand These keeps running on even after I stop using the servlet. When I stop-start tomcat they go away until I start using the servlet again. Obviously(?) I need to find a way to tell the MessageServiceHandler to stop polling for messages, but I can't seem to get at it. Can anyone advice me how to solve this? --=20 Med vennlig hilsen / Best Regards / Cordiali saluti Tiscali AS - Simen Skjervum (Amministratore di sistema) Postboks 598, Sk=F8yen - N-0214 Oslo - Norway Tel. (+47) 24 11 24 00 - Fax (+47) 24 11 24 11 |