Re: [PHP-DB] PHP and MySQL on Windows causing severe slowdown

2006-09-10 Thread Chris

Diane wrote:
 I just switched a customer from one Windows host to another. The new 
host is a Windows only shop, and not overly familiar with MySQL and PHP. 
My customer has two PHP applications, both important to the site. 
Everything else is ASP or ASP.NET.


When the new host installed PHP and MySQL, the website slowed down to a 
crawl. Troubleshooting identified the PHP module that connects to MySQL 
to be the problem. Remove the DLL and there is no problem. Restore the 
DLL and the problem returns. Neither PHP app is as yet installed, but we 
are still getting these problems. Needless to say, we need to access the 
databases!


The Windows server is OS: Windows Server 2003 Web Edition
Memory: 320 MB RAM
Disk: 15 GB SATA Raptor 10K RPM (Free Upgrade!)
Allotted Bandwidth: 100 GB Bandwidth

MySQL 4 was installed, but was replaced with MySQL 5, hoping this would 
solve the problem. It didn't. The PHP version is 5.1


Did you update the php_mysql.dll and associated files as well? The 
php_mysql.dll for mysql 4 will be different to the one for mysql 5.


What shows in the logs?

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] PHP and MySQL on Windows causing severe slowdown

2006-09-08 Thread Diane
 I just switched a customer from one Windows host to another. The new 
host is a Windows only shop, and not overly familiar with MySQL and PHP. 
My customer has two PHP applications, both important to the site. 
Everything else is ASP or ASP.NET.


When the new host installed PHP and MySQL, the website slowed down to a 
crawl. Troubleshooting identified the PHP module that connects to MySQL 
to be the problem. Remove the DLL and there is no problem. Restore the 
DLL and the problem returns. Neither PHP app is as yet installed, but we 
are still getting these problems. Needless to say, we need to access the 
databases!


The Windows server is OS: Windows Server 2003 Web Edition
Memory: 320 MB RAM
Disk: 15 GB SATA Raptor 10K RPM (Free Upgrade!)
Allotted Bandwidth: 100 GB Bandwidth

MySQL 4 was installed, but was replaced with MySQL 5, hoping this would 
solve the problem. It didn't. The PHP version is 5.1


Any and all help with this problem would be very much appreciated!

Diane

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php