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