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

[Scott A. McIntyre]

--On Thursday, January 08, 2004 19:36 -0500 Ben Goodwin 
<ben at atomicmatrix.net> wrote:

> 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:
>

Maybe I'm looking at the wrong thing, and perhaps this behaviour you talk 
of is mostly for RT3 (We're still on RT2), but I only ever see one rt_user 
session logged in to MySQL, regardless of how busy my Apache is.

"mysqladmin -v proc" is what I do to verify this.  When the system is idle, 
I only see:

| 6806 | rt_user | localhost | rt2 | Sleep   | 0    |       | 
|

But the number of processes is never greater than one for the rt_user. 
Perhaps I'm confusing the mysql threads and processes with unix processes 
(there being 13 mysqld processes running)....I'm not much into databases.

If there's something definitely wrong with what I'm seeing, that the 
mysqladmin -v proc should report many rt_user queries when the system is 
"busy" then I'd like to hear about it so I can figure out what's not tuned 
properly.


Thanks,
Scott