Re: A final Windows MySQL PHP plea
I have heard Apache croaks after 130 connections.. -M - Original Message - From: Nils Valentin [EMAIL PROTECTED] To: Andrew Rothwell [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 6:34 PM 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 E! Sorry - but Dual Proc Support, with 2gigs of RAM would Love Redhat 9.0 like a kid loves chocolate. I dont 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:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 10:04 PM To: Gary Broughton; [EMAIL PROTECTED] 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/power_ps2q03-jaffe.htm Best regards Nils Valentin Tokyo/Japan 2003 8 13 01:21Gary Broughton : 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: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 E! Sorry - but Dual Proc Support, with 2gigs of RAM would Love Redhat 9.0 like a kid loves chocolate. I dont 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:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 10:04 PM To: Gary Broughton; [EMAIL PROTECTED] 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/power_ps2q03-jaffe.htm Best regards Nils Valentin Tokyo/Japan 2003 8 13 01:21Gary Broughton : 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: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] 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/[EMAIL PROTECTED]
RE: A final Windows MySQL PHP plea
I think that if Apache did that - then it would certainly not be one of (Bthe most widely used Webservers in use today, and it would not be (Breviewed as extremely stable, IIS on the hand *smirks* (B (BAndrew (B (B-Original Message- (BFrom: Martin Gainty [mailto:[EMAIL PROTECTED] (BSent: Wednesday, August 13, 2003 11:00 PM (BTo: Nils Valentin; Andrew Rothwell (BCc: [EMAIL PROTECTED] (BSubject: Re: A final Windows MySQL PHP plea (B (B (BI have heard Apache croaks after 130 connections.. (B-M (B- Original Message - (BFrom: "Nils Valentin" [EMAIL PROTECTED] (BTo: "Andrew Rothwell" [EMAIL PROTECTED] (BCc: [EMAIL PROTECTED] (BSent: Wednesday, August 13, 2003 6:34 PM (BSubject: Re: A final Windows MySQL PHP plea (B (B (BHi Andrew, (B (BI guess your reply was meant for Gary (the original poster of this (Be-mail). (B (BI will foward your request to the mailing list. (B (BBest regards (B (BNils Valentin (BTokyo/Japan (B (B (B (B (B WOW!!! (B That kind of System Power and you are wasting it on Windows and IIS (B E! (B (B Sorry - but Dual Proc Support, with 2gigs of RAM would Love Redhat 9.0 (B (B like a kid loves chocolate. (B (B I don$B!G(Bt know about the more than 100 concurrent users, but bear in (B mind (as I understand it) that means that you can have up to 100 (B queries at 1 time, as soon as the query is over, the next user is (B available for his query. (B (B Linux itself can support 1000's of users at one time - (B You might be surprised. (B (B Andrew (B (B -Original Message- (B From: Nils Valentin [mailto:[EMAIL PROTECTED] (B Sent: Tuesday, August 12, 2003 10:04 PM (B To: Gary Broughton; [EMAIL PROTECTED] (B Subject: Re: A final Windows MySQL PHP plea (B (B (B Hi Gary, (B (B I understood that the packages provided by MySQL are set to 100 (B concurrent users by default, so what you ae asking is actually if (B somebody successfully (B compiled a version for more than 100 concurrent users and was able to (B use it (B in a production environment ? (B (B Do I understand that correct ? (B (B My guess would be that you are more likely to find Linux users having (B done such a setup. Unfortunately I haven'Tt had such an experience (B yet, but as you (B probably now Dell has made a study (which is also announced on (Bwww.mysq. (B com) (B which describes their experience, perhaps it contains the one or the (B other (B useful tip. (B (B http://www.dell.com/us/en/biz/topics/power_ps2q03-jaffe.htm (B (B Best regards (B (B Nils Valentin (B Tokyo/Japan (B (B 2003$BG/(B 8$B7n(B 13$BF|(B $B?eMKF|(B 01:21$B!"(BGary Broughton (B $B$5$s$O=q$-$^$7$?(B: (B Hi all (B (B Is there anybody out there who has managed to successfully configure (B (B Win2000, IIS5, MySQL 4.0.14 and PHP 4.3.2 (ISAPI) to work with a (B couple of hundred users at any one time? I have chucked absolutely (B everything I can think of at this, but the MySQL (it seems) simply (B eats all the available CPU within a short space of time (regardless (B of (B (B users) and brings the site to a halt. My last throw of the dice (B today (B (B was to install all on a new Dual 1.8Ghz Pentium, with three hard (B disks (B (B in a RAID array, and 2GB memory, but it's achieved pretty much (B nothing. I am now desperate, and if anyone has any flash of (B inspiration for me, I'm all ears. The previous ASP version of the (B site runs like a dream, but there's something I'm either doing (B wrong, or this new combination of software simply doesn't like. (B (B Many thanks (B (B Stressed Gary (B (B -- (B --- (B Valentin Nils (B Internet Technology (B (B E-Mail: [EMAIL PROTECTED] (B URL: http://www.knowd.co.jp (B Personal URL: http://www.knowd.co.jp/staff/nils (B (B-- (B--- (BValentin Nils (BInternet Technology (B (B E-Mail: [EMAIL PROTECTED] (B URL: http://www.knowd.co.jp (B Personal URL: http://www.knowd.co.jp/staff/nils (B (B (B-- (BMySQL General Mailing List (BFor list archives: http://lists.mysql.com/mysql (BTo unsubscribe: (Bhttp://lists.mysql.com/[EMAIL PROTECTED] (B (B (B (B-- (BMySQL General Mailing List (BFor list archives: http://lists.mysql.com/mysql (BTo unsubscribe: (Bhttp://lists.mysql.com/[EMAIL PROTECTED] (B (B (B (B (B (B-- (BMySQL General Mailing List (BFor list archives: http://lists.mysql.com/mysql (BTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: A final Windows MySQL PHP plea
Hi, On Tue, Aug 12, 2003 at 05:21:23PM +0100, Gary Broughton wrote: 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. You mention that this ran fine before. What was your previous setup? Did you switch from e.g. MS-SQL to MySQL? From MySQL 3.x to 4.x? You mention ASP vs PHP so your scripts must have changed. Did the queries change? Anyway, I run MySQL 3.23.x on Solaris, so I can't help you on specifics with your setup. But no amount of hardware will help against lacking optimization. So once you've made sure that the CPU time is actually used by MySQL, you might try to put log-slow-queries in your config. It will log slow queries in hostname-slow.log with 'slow queries' being defined as queries that run for more than 10 seconds (default). You can also try 'show processlist' from the MySQL client to see which queries are running and which queries are blocked because of locks by running queries. Once you have found slow queries, run EXPLAIN on them to determine if and how they are optimized. The manual has lots of info on optimization. If MySQL picks the wrong index, try using SELECT USE INDEX (...). Sometimes adding (redundant) fields containing a calculated value will allow you to create a good index (at the cost of making sure that the added field will remain consistent). There are lots of possibilities. Hope this helps. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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/power_ps2q03-jaffe.htm Best regards Nils Valentin Tokyo/Japan 2003 8 13 01:21Gary Broughton : 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: [EMAIL PROTECTED] 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/[EMAIL PROTECTED]
FW: A final Windows MySQL PHP plea
Thanks to everybody for all your help and advice. It seems Linux is (Bgoing to HAVE to be the next step, but while I know sod all about it, I (Bhave enlisted the help of a colleague to assist with that side of (Bthings. So I shall crack on with that, and subsequently let you know (Bwhat the outcome is. :-) (BThanks again (BGary (B (B-Original Message- (BFrom: Nils Valentin [mailto:[EMAIL PROTECTED] (BSent: 14 August 2003 02:35 (BTo: Andrew Rothwell (BCc: [EMAIL PROTECTED] (BSubject: Re: A final Windows MySQL PHP plea (B (B (BHi Andrew, (B (BI guess your reply was meant for Gary (the original poster of this (Be-mail). (B (BI will foward your request to the mailing list. (B (BBest regards (B (BNils Valentin (BTokyo/Japan (B (B (B (B (B WOW!!! (B That kind of System Power and you are wasting it on Windows and IIS (B E! (B (B Sorry - but Dual Proc Support, with 2gigs of RAM would Love Redhat 9.0 (B (B like a kid loves chocolate. (B (B I don$B!G(Bt know about the more than 100 concurrent users, but bear in (B mind (as I understand it) that means that you can have up to 100 (B queries at 1 time, as soon as the query is over, the next user is (B available for his query. (B (B Linux itself can support 1000's of users at one time - (B You might be surprised. (B (B Andrew (B (B -Original Message- (B From: Nils Valentin [mailto:[EMAIL PROTECTED] (B Sent: Tuesday, August 12, 2003 10:04 PM (B To: Gary Broughton; [EMAIL PROTECTED] (B Subject: Re: A final Windows MySQL PHP plea (B (B (B Hi Gary, (B (B I understood that the packages provided by MySQL are set to 100 (B concurrent users by default, so what you ae asking is actually if (B somebody successfully (B compiled a version for more than 100 concurrent users and was able to (B use it (B in a production environment ? (B (B Do I understand that correct ? (B (B My guess would be that you are more likely to find Linux users having (B done such a setup. Unfortunately I haven'Tt had such an experience (B yet, but as you (B probably now Dell has made a study (which is also announced on (Bwww.mysq. (B com) (B which describes their experience, perhaps it contains the one or the (B other (B useful tip. (B (B http://www.dell.com/us/en/biz/topics/power_ps2q03-jaffe.htm (B (B Best regards (B (B Nils Valentin (B Tokyo/Japan (B (B 2003$BG/(B 8$B7n(B 13$BF|(B $B?eMKF|(B 01:21$B!"(BGary Broughton (B $B$5$s$O=q$-$^$7$?(B: (B Hi all (B (B Is there anybody out there who has managed to successfully configure (B (B Win2000, IIS5, MySQL 4.0.14 and PHP 4.3.2 (ISAPI) to work with a (B couple of hundred users at any one time? I have chucked absolutely (B everything I can think of at this, but the MySQL (it seems) simply (B eats all the available CPU within a short space of time (regardless (B of (B (B users) and brings the site to a halt. My last throw of the dice (B today (B (B was to install all on a new Dual 1.8Ghz Pentium, with three hard (B disks (B (B in a RAID array, and 2GB memory, but it's achieved pretty much (B nothing. I am now desperate, and if anyone has any flash of (B inspiration for me, I'm all ears. The previous ASP version of the (B site runs like a dream, but there's something I'm either doing (B wrong, or this new combination of software simply doesn't like. (B (B Many thanks (B (B Stressed Gary (B (B -- (B --- (B Valentin Nils (B Internet Technology (B (B E-Mail: [EMAIL PROTECTED] (B URL: http://www.knowd.co.jp (B Personal URL: http://www.knowd.co.jp/staff/nils (B (B-- (B--- (BValentin Nils (BInternet Technology (B (B E-Mail: [EMAIL PROTECTED] (B URL: http://www.knowd.co.jp (B Personal URL: http://www.knowd.co.jp/staff/nils (B (B (B-- (BMySQL General Mailing List (BFor list archives: http://lists.mysql.com/mysql (BTo unsubscribe: (Bhttp://lists.mysql.com/[EMAIL PROTECTED] (B (B (B-- (BMySQL General Mailing List (BFor list archives: http://lists.mysql.com/mysql (BTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: A final Windows MySQL PHP plea
Gary Does your php code use persistent connections? mysql_pconnect() rather than mysql_connect() ? If so, that would ramp up the CPU usage fairly quickly, AFAIAA. Just a thought Terry --Original Message- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A final Windows MySQL PHP plea
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