[rt-users] RT3 is spawning 2 additional processes every time something is done

[Ben Goodwin]

Each httpd process will open a MySQL connection .. though MySQL should have
no problem going over 14 with the default config.  In any case to set your
default timeout (I suggest this for an application I wrote, too) use the
following in /etc/my.cnf:

[mysqld]
set-variable=wait_timeout=60

and restart mysql.

60 might be a little low, though.

Are you the only one accessing RT?  I'm wondering why different httpd's are
processing your request.  Are you running Apache 1.x or 2.x?

It's also funky that you have 3 sets of database connections, each between
134 and 143 seconds apart.  Perhaps apache's still got some issues?  Can you
set the following in your apache config (and restart) and then go to
http://your-server/server-status and paste the results (or summarize.. a
paste of the table might be ugly)?

ExtendedStatus On

<Location /server-status>
    SetHandler server-status
    Order deny,allow
    Deny from all
    Allow from your.ip.addr.ess
</Location>

    -=| Ben

----- Original Message ----- 
From: "Frank Saxton" <frankie at easyrider.com>
To: <rt-users at lists.bestpractical.com>
Sent: Thursday, January 08, 2004 4:48 PM
Subject: [rt-users] RT3 is spawning 2 additional processes every time
something is done


> Ben,
>
> Currently running 'ok'... I found a couple of missing binaries and now
that
> I've restored them from the tarball, I seem to be holding at 12 mysqld
> processes.  Don't know what will happen if I open a second RT GUI though.
>
> I think A.J. may have had an excellent suggestion about wait_timeout
> though.  It's set at 28800!!!!  I tried putting wait_timeout = 60 in the
> [mysqld] field but apparently I am using the wrong syntax or I am putting
> it in the wrong place.  A 5 second crash course on my.cnf would really
help!
>
> [root at rt rt3]# /etc/init.d/mysqld status
> mysqld (pid 26778 26777 26716 26715 26665 26664 26634 26633 26632 26630)
is
> runn
> ing...
> [root at rt rt3]# mysql -e 'show processlist'
>
+----+---------+-----------+------+---------+------+-------+----------------
--+
> | Id | User    | Host      | db   | Command | Time | State | Info
|
>
+----+---------+-----------+------+---------+------+-------+----------------
--+
> |  1 | rt_user | localhost | rt3  | Sleep   | 420  |       | NULL
|
> |  2 | rt_user | localhost | rt3  | Sleep   | 419  |       | NULL
|
> |  3 | rt_user | localhost | rt3  | Sleep   | 277  |       | NULL
|
> |  4 | rt_user | localhost | rt3  | Sleep   | 277  |       | NULL
|
> |  7 | rt_user | localhost | rt3  | Sleep   | 134  |       | NULL
|
> |  8 | rt_user | localhost | rt3  | Sleep   | 134  |       | NULL
|
> |  9 | root    | localhost | NULL | Query   | 0    | NULL  | show
processlist |
>
+----+---------+-----------+------+---------+------+-------+----------------
--+
> [root at rt rt3]#
>