Background:
A single transaction 1 ms SQL execution time (select)
Concurrent 30 pen, with a SQL execution time increases to 10 ms
After the update, insert and almost in concurrent response time increased to more than 10 times, could you tell me this delay is normal?
Because after concurrent TPS couldn't get on, the CPU memory at about 10%, but the transaction response time has soared,
Please give directions, thank you!

CodePudding user response:

Concurrent how to do? Code? 30 SQL running at the same time?

CodePudding user response:

reference 1st floor yaiger response:

do concurrent? Code? 30 SQL running at the same time?

Not do with 30 SQL running at the same time, is the performance tester writing code,

CodePudding user response:

Said the illegibility of, how can I help? Specific SQL have? The execution plan have?

CodePudding user response:

Who runs AWR report had better test period, or ASH report

CodePudding user response:

You should be doing pressure test, the CPU memory at about 10%, looks data volume pressure is not big, can consider to whether applications reach bottleneck, try a few more nodes