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

Maybe your servers are ok but the connection between them is slow? Broken? Firewalls? Gary Broughton wrote:

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