|
Posted by NC on 03/29/06 21:27
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
Navigation:
[Reply to this message]
|