I would also strongly recommend the event mpm over prefork, in any scenario. The fact that you are trying to tweak prefork likely means that you inherited a legacy prefork and mod_php configuration, which is just not going to cut it any more. For dynamic requests, look into fcgi.

Having a separate machine with httpd, and dynamic content servers is likely to scale far better, I agree with that suggestion.

At some point, you will saturate your I/O subsystem, and that means terrible performance for all services on that host.

On Sun, 15 Nov 2020 at 14:12, James Smith <js5@sanger.ac.uk> wrote:
It's not clear why you would need to serve that many "concurrent" connections, a bit more information would be required.

 * What is your dynamic content being generated by, is it running inside apache, or is it running on it's own "server" and being to proxied by Apache?
 * Is content mainly static or dynamic?
 * Is the database a large number of small entries, or a smaller number of large entries?
 * Is it nearly all reads or contains lots of writes as well?
 * Are both the MySQL and the database on the same server?

My gut feeling (and experience) would suggest that you would almost certainly come into issues trying to put that workload on a single server, you can tune to a certain extent but then you will get to the limits of the server.

Have you done any benchmarking on your current set up - using something like Apache Bench or Siege? How many concurrent connections can it handle?


-----Original Message-----
From: Massimo Iovino <massimo.iovino@gmail.com>
Sent: 14 November 2020 09:35
To: users@httpd.apache.org
Subject: [users@httpd] apache tuning for 1500/2000 concurrent connections [EXT]

Hello everyone. I need to configure Apache 2.4 mpm-prefork (or I don't know if mpm-worker is better) for about 1500/2000 concurrent connections (even up to 4000). These are the characteristics of the server: Server
Version: Apache / 2.4.46 MPM server: prefork Server: 12-core Intel (R) Core (TM) i7-8700 CPU @ 3.20GHz Speed: 800.000 MHz Cache: 12288 KB
Memory: 128GB RDBMS: mySQL 5.7 Can anyone give me some advice on how to configure Apache? Do you have to do anything in particular about the mySQL configuration? Thanks a lot to everyone Massimo

To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org

 The Wellcome Sanger Institute is operated by Genome Research
 Limited, a charity registered in England with number 1021457 and a
 company registered in England with number 2742969, whose registered
 office is 215 Euston Road, London, NW1 2BE.

To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org