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**@knowd.co.jp]
Sent: 14 August 2003 02:35
To: Andrew Rothwell
Cc: my***@lists.mysql.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**@knowd.co.jp]
Sent: Tuesday, August 12, 2003 10:04 PM
To: Gary Broughton; my***@lists.mysql.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!"(BGary 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.jp
URL: http://www.knowd.co.jp
Personal URL: http://www.knowd.co.jp/staff/nils
--
---
Valentin Nils
Internet Technology
E-Mail: ni**@knowd.co.jp
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