set-variable = key_buffer_size=100MB set-variable = read_buffer_size=5M set-variable = table_cache=500 set-variable = max_delayed_threads=0 set-variable = max_user_connections=25 set-variable = query_cache_size=50M set-variable = thread_cache_size=100
The only problem I couldn't solve is that some connections will never die... since most of this connections come from tomcat, I'm restarting it more often.
Using query cache and thread cache will definetely give you a boost of performance
This machine has lots of memory, so you have to be careful with variables like key_buffer_size, table_cache and query_cache_size... you need memory for that, don't let it swap.
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. 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.
Lalo
Gunnar Helliesen wrote:
On Sat, 22 Jun 2002 17:43:12 -0700 Jeremy Zawodny wrote:
On Sat, Jun 22, 2002 at 07:26:36PM -0500, mos wrote:
Yeah, I mostly ingored them because I thought it was a fluke. But it happens much more than I had thought.We've managed to reproduce this pretty reliably at Yahoo and are working to track and fix the bug. If we find a resolution, I'll post a note here.
There have been a few threads regarding high CPU utilization on FreeBSD systems.
It's still happening on the site I first reported it on. We're currently running max-4.0.11-gamma, but the problem has been present since 3.x. FreeBSD 4.4 and 4.5.
-- -------------------------------------------------------------------------- Gustavo Baratto - Programming and Technical Support [EMAIL PROTECTED] * (604) 638-2525 ext. 408
Technical support web-site: http://support.superb.net Superb Internet Corp. "Ahead of the Rest" -------------------------------------------------------------------------
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
