Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Open
mikk150 opened this issue Oct 24, 2018 · 0 comments
Open

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

mikk150 opened this issue Oct 24, 2018 · 0 comments
Labels
type:bug Bug

Comments

@mikk150
Copy link

mikk150 commented Oct 24, 2018

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 mikk150 mentioned this issue Oct 24, 2018
Open
@mikk150 mikk150 changed the title DB queue is extremely slow if there are many delayed jobs [yii\queue\db\Queue::reserve()] is extremely slow if there are many delayed jobs Oct 24, 2018
@samdark samdark added the type:bug Bug label Oct 25, 2018
@mikk150 mikk150 mentioned this issue Sep 1, 2020
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
type:bug Bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@samdark @mikk150