FW: A final Windows MySQL PHP plea

[Gary Broughton]

Thanks to everybody for all your help and advice. It seems Linux is
going to HAVE to be the next step, but while I know sod all about it, I
have enlisted the help of a colleague to assist with that side of
things. So I shall crack on with that, and subsequently let you know
what the outcome is. :-)
Thanks again
Gary

-----Original Message-----
From: Nils Valentin [mailto:ni**@kno wd.co.jp]
Sent: 14 August 2003 02:35
To: Andrew Rothwell
Cc: my***@lists.mys ql.com
Subject: Re: A final Windows MySQL PHP plea
Hi Andrew,

I guess your reply was meant for Gary (the original poster of this
e-mail).

I will foward your request to the mailing list.

Best regards

Nils Valentin
Tokyo/Japan
--------

WOW!!!
That kind of System Power and you are wasting it on Windows and IIS
EWWWW!

Sorry - but Dual Proc Support, with 2gigs of RAM would Love Redhat 9.0 like a kid loves chocolate.

I don$B!G(Bt know about the more than 100 concurrent users, but bear in
mind (as I understand it) that means that you can have up to 100
queries at 1 time, as soon as the query is over, the next user is
available for his query.

Linux itself can support 1000's of users at one time -
You might be surprised.

Andrew

-----Original Message-----
From: Nils Valentin [mailto:ni**@kno wd.co.jp]
Sent: Tuesday, August 12, 2003 10:04 PM
To: Gary Broughton; my***@lists.mys ql.com
Subject: Re: A final Windows MySQL PHP plea
Hi Gary,

I understood that the packages provided by MySQL are set to 100
concurrent users by default, so what you ae asking is actually if
somebody successfully
compiled a version for more than 100 concurrent users and was able to
use it
in a production environment ?

Do I understand that correct ?

My guess would be that you are more likely to find Linux users having
done such a setup. Unfortunately I haven'Tt had such an experience
yet, but as you
probably now Dell has made a study (which is also announced on www.mysq. com)
which describes their experience, perhaps it contains the one or the
other
useful tip.

http://www.dell.com/us/en/biz/topics...2q03-jaffe.htm

Best regards

Nils Valentin
Tokyo/Japan

2003$BG/(B 8$B7n(B 13$BF|(B $B?eMKF|(B 01:21$B!"(BGa ry Broughton $B$5$s$O=q$-$^$7$?(B:

Hi all

Is there anybody out there who has managed to successfully configure Win2000, IIS5, MySQL 4.0.14 and PHP 4.3.2 (ISAPI) to work with a
couple of hundred users at any one time? I have chucked absolutely
everything I can think of at this, but the MySQL (it seems) simply
eats all the available CPU within a short space of time (regardless
of

users) and brings the site to a halt. My last throw of the dice
today

was to install all on a new Dual 1.8Ghz Pentium, with three hard
disks

in a RAID array, and 2GB memory, but it's achieved pretty much
nothing. I am now desperate, and if anyone has any flash of
inspiration for me, I'm all ears. The previous ASP version of the
site runs like a dream, but there's something I'm either doing
wrong, or this new combination of software simply doesn't like.

Many thanks

Stressed Gary

--
---
Valentin Nils
Internet Technology

E-Mail: ni**@knowd.co.j p
URL: http://www.knowd.co.jp
Personal URL: http://www.knowd.co.jp/staff/nils

--
---
Valentin Nils
Internet Technology

E-Mail: ni**@knowd.co.j p
URL: http://www.knowd.co.jp
Personal URL: http://www.knowd.co.jp/staff/nils
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/my***********...*@footymad.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw