Re: Apache / PHP/ MySQL - user limits
- From: "NC" <nc@xxxxxxxxx>
- Date: 29 Mar 2006 10:27:29 -0800
Ian Robinson wrote:
I'm new to web server development and am wondering
if I have chosen correctly for a planned development
of moving a desktop application to a web server
environment. The desktop application is an inventory
stock control / invoicing program running on 200 desktops.
At what level of concurrent users do we start to meet
limitation problems / performance hits
This is a complicated question. There are at least two places where
you can define maximum number of concurrent users. One is Apache
configuration file; there, you define the maximum number of HTTP
requests Apache can serve simultaneously. The other is MySQL
configuration file; there, you define the maximum number of
simultaneous connections that MySQL will accept. However, you must
remember that each connection requires a certain amount of memory, so
your settings must be appropriate for the amount of physical memory
your machine has.
In practice, it is often advisable to spread a high-load application
between two physical machines, one running only HTTP server, the other
running only MySQL server. This way, you can deal with Apache
fine-tuning and MySQL fine-tuning separately, and they won't fight for
memory as they would on a single physical machine.
A lot will depend on the quality of your hardware, especially on the
MySQL side. Fast hard drives in a RAID configuration can dramatically
speed up the response time...
Cheers,
NC
.
- References:
- Apache / PHP/ MySQL - user limits
- From: Ian Robinson
- Apache / PHP/ MySQL - user limits
- Prev by Date: Re: newbie simple problem with cookie
- Next by Date: php include newbie question
- Previous by thread: Re: Apache / PHP/ MySQL - user limits
- Next by thread: newbie simple problem with cookie
- Index(es):
Relevant Pages
|
