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]