activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jeesim2 <jees...@gmail.com>
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.


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

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


PURPOSE
- 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 http://activemq.apache.org/delay-and-schedule-message-delivery.html can
not help me.


I wish you understand me : )


thankyou.

--
View this message in context: http://activemq.2283324.n4.nabble.com/How-to-make-queues-not-to-be-comsumed-until-queue-size-exceed-some-value-tp4296516p4296516.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.

Mime
View raw message