How can I set queueLimit for MySQL pool?

[sandinmyjoints]

Issue Description

• node-mysql and mysql2 support a pool option called queueLimit which configures what to do with incoming requests when all connections in a pool are in use. How can I get similar behavior with sequelize?

What was unclear/insufficient/not covered in the documentation

• after looking through the docs and code (of both sequelize and sequelize-pool), I can't tell if it's possible to set this option via sequelize or not, though I'm leaning towards not possible as it seems like pooling is all handled by sequelize-pool and I don't see any reference to a queue limit in there, only "If creating a new client would exceed the maximum, add the client to the wait list."
• this seems suboptimal since if the rate of incoming requests exceeds the rate of responses, the wait list will grow until it causes problems
• if there isn't a way to get this behavior with sequelize-pool, is it possible to opt out of sequelize-pool and use mysql2's pool instead?

Additional context

Issue Template Checklist

Is this issue dialect-specific?

• No. This issue is relevant to Sequelize as a whole.
• Yes. This issue only applies to the following dialect(s): XXX, YYY, ZZZ
• I don't know.

Would you be willing to resolve this issue by submitting a Pull Request?

• Yes, I have the time and I know how to start.
• Yes, I have the time but I don't know how to start, I would need guidance.
• No, I don't have the time, although I believe I could do it if I had the time...
• No, I don't have the time and I wouldn't even know how to start.

[github-actions]

This issue has been automatically marked as stale because it has been open for 7 days without activity. It will be closed if no further activity occurs. If this is still an issue, just leave a comment or remove the "stale" label. 🙂