MySQL/MariaDB performance

[cristian]

How can I affect resource allocation for MySQL/MariaDB?

[anton]

Today I have run some simple stresstests, that I wrote myself - PHP script that inserts 1000000 records, does random search and random insert/sel ect fr om 200 tables.

I was shocked, that it took so much more time on CloudLinux comparing to plain Centos server. Fr om that I can conclude, that there must be some resource allocation per mysql user in a same way, as for any other user.. Question is - what is the right way to remove these limits? Wh ere are these settings located?

Regards,
Anotn

[anton]

Just to note - we don have mysql governor installed, but we use CageFS. Our goal is provide max mysql performance on this server.

[bogdan.sh]

If no mysql-governor installed then we do nothing with mysql service or user, there should not be big difference between CentOS and CloudLiux on managing mysql requests. And.. actually its not right to compare same things on different servers as every simple detail does matter.

The best thing I can propose is to take clean server with CentOS , do test on it then convert to CloudLinux and perform test again.