Database very slow performance.

[DracoBlue]

Username:

TITLE

Database very slow performance.

PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE

Latest

PROBLEM DESCRIPTION

a lot of people have problems with database performance with plesk panel

STEPS TO REPRODUCE

Question - Poor wordpress database performance on Plesk server... any ideas?

ACTUAL RESULT

Question - Poor wordpress database performance on Plesk server... any ideas?

EXPECTED RESULT

Question - Poor wordpress database performance on Plesk server... any ideas?

ANY ADDITIONAL INFORMATION

Question - Poor wordpress database performance on Plesk server... any ideas?

YOUR EXPECTATIONS FROM PLESK SERVICE TEAM

Confirm bug

 

[Adam Makowski]

Please do not use software that does not serve this purpose, plugins for WordPress are not authoritative.
Use example sysbench : How to benchmark Managed Databases on UpCloud
My score for reads:

 

[IgorG]

@DracoBlue, sorry, but I can't forward such a formally composed report to developers. Please format it adequately with all the necessary details without following all the links.

 

[Adam Makowski]

So it is not the fault of Plesk. MariaDB installs with default settings. It needs to be tuned for higher load.
I did some more benchmarks today:
around 13.000 queries/second read
around 20.000 queries/second write

with only 4 CPU

So your problems are just server settings