Slow Performance When Running Same SQL In Parallel Several Times
(Doc ID 2798201.1)
Last updated on AUGUST 26, 2021
Applies to:MySQL Server - Version 5.7 and later
Information in this document applies to any platform.
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.
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