List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:August 7 2003 9:55pm
Subject:Re: Mysql processlist sleep time
View as plain text  
On Thu, Aug 07, 2003 at 07:54:24PM +0100, Gary Broughton wrote:
> Hi all
>
> I continue to have problems with the CPU usage with MySQL and PHP
> under IIS 5 (Win2000).  I recently rewrote our messageboards in PHP
> (from ASP).  I now have both online separately, and if I look at the
> processlist, the times on the ASP version rarely hit double figures,
> but those on the PHP version often reach several hundred (wait and
> inactivity timeouts are set to 300 - I thought this would stop
> it?!).

I'm not sure what the problem is.  From your description, it sounds as
if the PHP one is either used less or is more efficient about using
connections, since they're idle more often.

> I am at a real loss as to why the processes are not being cleared.
> I am using a persistent connection at the top of the webpage, and
> every MySQL query is ended with a 'mysql_free_result()' statement,
> including before any redirects using the 'header' command.

Hang on.  You're using *persistent* connections, so why would you
expect them not to persist?

Jeremy
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped>  |  http://jeremy.zawodny.com/

MySQL 4.0.13: up 6 days, processed 212,516,276 queries (399/sec. avg)
Thread
Mysql processlist sleep timeGary Broughton7 Aug
  • Re: Mysql processlist sleep timeJeremy Zawodny7 Aug
    • RE: Mysql processlist sleep timeGary Broughton8 Aug
      • RE: Mysql processlist sleep timeAdam Nelson8 Aug
        • RE: Mysql processlist sleep timeGary Broughton8 Aug
    • RE: Mysql processlist sleep timeAdam Nelson8 Aug