Re: PHP 4.3.2, Windows 2000 IIS 5, MySQL 4.013 CPU usage problem

Hi guys Many thanks for your replies. I did originally use the CGI version, but earlier today built a second machine, and clean installed IIS5 and PHP 4.3.2 onto it, using the ISAPI module - and now connect to the remote MySQL database. Unfortunately, I'm getting pretty much the same 100% usage from the mysqld-nt on the database server (although it occasionally drops for a few seconds every minute or two). I've also tried mysqld-max-nt and mysqld-opt, but there is no difference. I use the 'mysql_pconnect()' option on my php pages, and indeed the 'mysql.allow.persistent' is set to 'on'. I just don't get it, especially as the ASP version runs efficiently! Confused and frustrated! It's probably going to simply need another parameter or two setting, but I'll be damned if I can find the answer! Any more suggestions would be more than welcome. "Sek-Mun Wong" <sekmun@connectingspace.com> wrote in message news:<20030806085023.88543.qmail@pb1.pair.com>... > are you running php4isapi.dll (ISAPI) or php.exe (CGI) version? > > I know people recommend CGI, but post 4.2.3, the ISAPI version is very > stable and you'd be nuts to run a busy site in CGI mode. > > If you're running CGI, here is an explanation: > The most expensive operation is the *connection*, why mysql gets > flogged is because every time you close down a php script, it dies and > the connection dies, so a new one needs to be re-established. It can > take only 10-20 concurrent connections to kill the server. > > To "fix" this (it's more an infrastructure issue, really): > > 1) run ISAPI version of php > 2) under [MySql] in php.ini, make sure > > mysql.allow_persistent = On > > You'll be amazed at the difference. > > > "Gary Broughton" <gbroughton@footymad.net> wrote in message > news:20030806081309.73189.qmail@pb1.pair.com... > > I wonder if anyone could offer any advice. We have a series of > > message boards using a MySQL database running under ASP on Windows > > 2000 IIS 5 > fine. > > Today I put the a PHP version live after it had been tested over the > weekend > > with about 20 users. As soon as I enabled PHP on the live website > (separate > > to the test PHP already running), the CPU usage for MySQL-nt went up > > to > 100% > > constantly, making the site run at a crawl. After uninstalling PHP > > and reverting to the ASP version for the live site, it all ran > > smoothly again. I have the Application set to Low (IIS Process) on > > both sites, the cgi.force_redirect is 0 as required, and the machine > > is a dual 1.8G > Pentium > > with 512MB of memory (I know this could do with doubling, but why is > > it > okay > > running ASP code?). I've scoured the net looking for any > > suggestions, but without coming across anything concrete. Has > > anyone any ideas I could try out at all? Many thanks > > Gary Broughton > > > > >