You are here: Re: Apache / PHP/ MySQL - user limits « All PHP « IT news, forums, messages
Re: Apache / PHP/ MySQL - user limits

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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация