From: [EMAIL PROTECTED] Operating system: Windows 2000 Advanced Server PHP version: 4.2.3 PHP Bug Type: IIS related Bug description: Isapi/mssql crashes under high load.
System Specifications - System Windows 2000 Advanced Server - IIS5 - tested php 4.06, 4.1.2, 4.2.3 (last version tested 4.2.3) - Dual Pentium IV 1.2 GHz - Database SQL Server 2000 Problems - System runs fine under ISAPI until high load at which point database refuses to connect, or IIS locks, computer requires reboot. Under ISAPI CPU runs at about 60%. - Same code/same system runs fine under CGI but CPU runs at 100%. Memory only at 20-30%, no virtual memory in use, database on seperate server running at 5% CPU. - Individual database connection times are under 2 milliseconds for ISAPI, however under CGI they are about 150-300 milliseconds. When using CGI, there are at least 3 expensive database connections per page (however after 3 connections they seem to be pooled as they are around 2-3 ms) cause page times be at least .5 - .8 seconds per page of PURE database connect time (connect time tends to be 60-80% of page time). - Similar pages running under Linux and FreeBSD show no signs of such problems, same under isapi however as stated above as soon as server load gets above 100-200 page hits per second server problems begin. Many refused http connections, many refused database connections, then server crashes causing machine to need reboot (restarting IIS does not solve the problem), causing VERY pissed off client who now believes that PHP is not an enterprise ready solution and only for home/hobbiest use. - No mention on web site that PHP was not ready for prouduction under IIS/Mssql. -- Edit bug report at http://bugs.php.net/?id=20330&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=20330&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=20330&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=20330&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=20330&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=20330&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=20330&r=support Expected behavior: http://bugs.php.net/fix.php?id=20330&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=20330&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=20330&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=20330&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=20330&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=20330&r=dst IIS Stability: http://bugs.php.net/fix.php?id=20330&r=isapi
