On Mon, Jun 09, 2003 at 11:26:36AM -0700, Lalo Castro wrote:
>
> We had the same problem.  Upgrading Freebsd to 4.8 and recompiling
> MySQL to work with Linux style threads seemed to work.

Great.

> The MySQLd process no longer pops up to ~90% on each request.
> However, with the application we're running that queries the
> database (Request Tracker 3), we still get process bloat with
> certain queries (searches mostly).  But, this problem doesn't come
> up with any other application, or with manual querys of the
> database, so we think it's a bug in the app.

Is this "process bloat" on the MySQL site or on the RT/Perl side?  If
it's on the MySQL side, can you describe it a bit and perhaps post
your my.cnf file along with a sample query and table structure that
tends to trigger the bloat?

I suspect that if it's a design deficiency in RT, Jesse and the folks
at Best Practical would like to fix it.

Jeremy
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 4.0.13: up 6 days, processed 195,846,290 queries (348/sec. avg)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to