How to Fine Tuning Apache?

[Adhenra]

Hi,

as I see by “top” in server,

Apache running much process than Nginx,

I want to configure apache like Nginx running in this Image

my current apache prefork:

<IfModule mpm_prefork_module>
    StartServers          8
    MinSpareServers       5
    MaxSpareServers      20
    ServerLimit         256
    MaxClients          200
    MaxRequestsPerChild 4000
</IfModule>

[eris]

You can’t as Apache2 in prefork mode doesn’t work like this.
I assume you use ModPHP for Aapche2?

Switch over to PHP-FPM and after that to Apache2 + MPM Event And ather that probally a lot of things need to be changed due to configuration differences between modphp and PHP-FPM. I see YouTube-dl running as a process so I assume it is a video website. Make sure you include the video file extensions in the proxy extensions.

[Adhenra]

Thank you for reply,

I have one more confusion about database?

I have large MyIsam engine database tables, 4GB

which file I have to optimize for database queries,

1. /etc/mysql/my.cnf
2. /etc/mysql/mariadb.conf.d/50-server.cnf

or some other file? and please suggest me some optimization settings