Issue need help?

[marshland09]

Hi all,
I'm running an Ubuntu server with Plesk Onyx for a while now.
And due a growth of database transactions the tables of other databases are getting slower.

I think this might be solved using a separated MySQL instance per domain?
What would be the best approach to get this up and running?
Any idea's advice or other feedback, please let me know!

 

[MarkM]

I’d start with the following to help tune it;
major/MySQLTuner-perl

From there, you could explore having an external MySQL server or even a cluster.