Comments on: Misimproving performance problems with INSERT DELAYED https://shlomi-noach.github.io/blog/mysql/misimproving-performance-problems-with-insert-delayed Blog by Shlomi Noach Fri, 15 Jan 2010 06:58:40 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: shlomi https://shlomi-noach.github.io/blog/mysql/misimproving-performance-problems-with-insert-delayed/comment-page-1#comment-9394 Fri, 15 Jan 2010 06:58:40 +0000 https://shlomi-noach.github.io/blog/?p=1745#comment-9394 Hi Morgan,
Thanks for the clarification 🙂

]]> By: Morgan Tocker https://shlomi-noach.github.io/blog/mysql/misimproving-performance-problems-with-insert-delayed/comment-page-1#comment-9392 Fri, 15 Jan 2010 06:09:42 +0000 https://shlomi-noach.github.io/blog/?p=1745#comment-9392 Hi Shlomi,

Great post. While I agree with you, I would clarify one thing:

Performance is really the measure of two things; (a) response (b) capacity. INSERT delayed doesn’t improve capacity in any way, but it can reduce the amount of time a user is sitting there waiting if the app is single threaded (like many web apps are). Having said that, I’ve never liked it. I’ve often thought of it as like a poor man’s asynchronous queue.

In many cases the right tool is probably a message queuing system designed for this problem like openmq/activemq/rabbitmq etc.

]]>