Slow Performance When Running Same SQL In Parallel Several Times
(Doc ID 2798201.1)
Last updated on OCTOBER 19, 2021
Applies to:
MySQL Server - Version 5.7 and laterInformation in this document applies to any platform.
Symptoms
It can be the case that slow performance is exhibited on some queries when running in parallel several times
If a simple query is executed and it takes 1 second, it may be seen that executing the same query in 5 different sessions that each query might take ~ 5 seconds.
Essentially the queries take the same amount of time to execute in parallel as they would to execute in sequence from the same session.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |