Re: How do I choose the best settings for the Apache Server?

[Frank Gingras <thumbs@xxxxxxxxxx>]

Just comment out the LoadModule line for prefork, and uncomment the line for event.

There is no "template"; you just need to tweak event to spawn more workers if needed, but the default settings should be fine for small volumes.

The prefork mpm should really be avoided at this point, as it spawns a separate process for every single HTTP request.

On Thu, Sep 14, 2023 at 2:47 PM Jason Long <hack3rcon@xxxxxxxxx.invalid> wrote:

Hello,

Thanks again.

So, I must remove the "mpm_prefork_module" section. Am I right?

Can you show me an Apache configuration template for use with Wordpress?

When I must use "mpm_prefork_module"?

On Thu, Sep 14, 2023 at 4:24 PM, Frank Gingras

<thumbs@xxxxxxxxxx> wrote:

500MB of RAM for the httpd processes, yes. The rest of the RAM will go towards php and MySQL.

Since wordpress is involved, you'll want to use the event mpm (nor prefork, nor event), proxy_fcgi and php-fpm. See:

https://cwiki.apache.org/confluence/display/HTTPD/PHP-FPM

On Thu, Sep 14, 2023 at 6:21 AM Jason Long <hack3rcon@xxxxxxxxx> wrote:

Hello,

Thank you so much for your reply.

Can you tell me more about "It should run well under 500MB even with thousands of workers."? Do you mean 500 MB memory?

My server uses WordPress, so it also has PHP and MySQL. What parameters should I change?

What is the formula for calculating "mpm_prefork_module" and "mpm_worker_module"

parameters?

On Wed, Sep 13, 2023 at 5:00 PM, Francois Gingras

<francois.gingras@xxxxxxxxx> wrote:

You'll want to make sure you're using the event mpm, in any case. It should run well under 500MB even with thousands of workers.

If php or another dynamic language is involved, then the answer will depend on what you use. You should also consider if other services use RAM, such as a rdbms.

On Wed, Sep 13, 2023 at 8:52 AM Jason Long <hack3rcon@xxxxxxxxx.invalid> wrote:

Hello,
My server has 6 GB RAM and 4 virtual CPUs. I want to know How can I change the following settings for better performance?


Timeout 45
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 15

<IfModule mpm_prefork_module>
    StartServers                 3
    MinSpareServers         3
    MaxSpareServers        3
    ServerLimit                   50
    MaxClients                    50
    MaxRequestsPerChild  1000
</IfModule>

<IfModule mpm_worker_module>
    StartServers              3
    MaxClients                50
    MinSpareThreads     3
    MaxSpareThreads    3 
    ThreadsPerChild       25
    MaxRequestsPerChild  1000
</IfModule>


I'm thankful if anyone can guide me to choose the above settings according to my server hardware specifications. If you know of other settings, please share.


Thank you. 

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx
For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx