Hi Dan Thanks for your reply. No, the process list was showing say 20 or 30 users with just milliseconds of activity, the only one on for any great length of time was myself as root. Stopping the service does return the machine to normality, but then it shoots right back up to 100% within seconds of restarting. I've used the mysqld-nt, mysql-max-nt and mysqld-opt executables, but the result is just the same.
I can't understand why this problem has occurred though - in it's current environment of one IIS site using the ASP board (95% of users - live) and one IIS site using the new PHP (5% - test) it runs like a dream, but when I enable PHP on the live site and direct all to that, it just collapses. I'm pretty sure all the settings for the two sites are identical, and the my.ini and php.ini obviously are not changed! Regards Gary -----Original Message----- From: Dan [mailto:[EMAIL PROTECTED] Sent: 04 August 2003 21:59 To: Gary Broughton; [EMAIL PROTECTED] Subject: Re: MySQL, IIS and PHP Gary Broughton wrote: >Hi all > >I've just recoded a website in PHP from ASP, running off IIS 5. It has >been tested by a dozen users over the weekend, but now I have put it >live the CPU utilisation is up at 100%, mainly swallowed up by >mysql-nt.exe. I wondered if anyone could offer any advice as to why >this could be (the MySQL settings have not changed, and are as they >were when it was accessed via the ASP code). > >Regards > >Gary > > > > What does 'mysqladmin processlist -p PASSWORD' give? Are there any processes that have been running for ages? What about if you shut down MySQL and restart it? -- 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]
