The server is heavily loaded, what are the solutions?

Question

Network administration

Welcome all. A chat is installed on the server, which heavily loads the database.
It was suggested to include the mpm_worker module and translate it into php_fpm
Apache and Muscle are installed on the server. Php version 7.2
Will this fix the problem ?
Now works with the mpm_prefork module.
I tried to enable the mpm_worker module, but it only works when I disable php, if I try to enable php it gives an error.

Answer 1

If the main load is on the database, then changing mpm is like a dead poultice.
See why the database eats resources. Limits may be too high, there are no indexes, crooked queries.

Answer 2

For multi-threaded Apache, php must be multi-threaded too. Of course, changing to multithreading will give some gain. But the main load is the work of the database. See what the database server says, what statistics, maybe there are not enough resources, maybe you need to add indexes.