activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jeesim2 <>
Subject How to make queues not to be comsumed until queue size exceed some value?
Date Sun, 15 Jan 2012 09:54:57 GMT
I'm sorry, My english is not good : )

I have some problem in my system that is..
between AM01 ~ AM02, there are too many user request to some URL.
so, significant "mysql insert statement(sql1)" processed, and mysql table
locked, and web service get out of order.
( 500,000 insert sql1 queries in a hour )

So, I hope sql1 queries processed asynchronously, for example, 500,000 sql1
queries processed during 3 hours.

and I thought activeMQ+SpringJMS could be a solution.

But, If [activeMQ+SpringJMS] does not support some delayed consummtion
mechanism, it can not be a solution.

[Webservice] --> [500,000 Insert queries in an hour ] --> [MYSQL]

[Webservice] -->(JMS)-->[ActiveMQ] ---> [500,000 insert queries scattered to
3 hours]---> [Cunsumer] -->[MYSQL]

- scatter the pick time's mysql insert statement widely.

Is there any way that solve my problem?
something like, 'consum a queue per a second' , or give interval between
queue consumtion.

each insert queries data are different, 
so can
not help me.

I wish you understand me : )


View this message in context:
Sent from the ActiveMQ - User mailing list archive at

View raw message