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:nils@knowd.co.jp]
Sent: 14 August 2003 02:35
To: Andrew Rothwell
Cc:
mysql@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
--------
[color=blue]
> 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[/color]
[color=blue]
> 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:nils@knowd.co.jp]
> Sent: Tuesday, August 12, 2003 10:04 PM
> To: Gary Broughton;
mysql@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[/color]
www.mysq.[color=blue]
> 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:[color=green]
> > Hi all
> >
> > Is there anybody out there who has managed to successfully configure[/color][/color]
[color=blue][color=green]
> > 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[/color]
>
> --
> ---
> Valentin Nils
> Internet Technology
>
> E-Mail:
nils@knowd.co.jp
> URL:
http://www.knowd.co.jp
> Personal URL:
http://www.knowd.co.jp/staff/nils[/color]
--
---
Valentin Nils
Internet Technology
E-Mail:
nils@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/mysql?unsub=g...n@footymad.net
--
MySQL General Mailing List
For list archives:
http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw 
