yii2-queue icon indicating copy to clipboard operation
yii2-queue copied to clipboard

[yii\queue\db\Queue::reserve()] is extremely slow if there are many delayed jobs

Open mikk150 opened this issue 5 years ago • 0 comments

What steps will reproduce the problem?

Make DB queue with 200k+ jobs on delayed list

What's expected?

fetching jobs from queue should be fast

What do you get instead?

since fetching jobs from queue takes 3+ seconds, additional workers get mutex timeout

Additional info

Q A
Yii version 2.0.15.1
PHP version 7.2.9
Operating system Debian 9

mikk150 avatar Oct 24 '18 12:10 mikk150