My Oracle Support Banner

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.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.