List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:October 6 2004 2:35am
Subject:Re: Memory problems
View as plain text  
In the last episode (Oct 05), Doug Wolfgram said:
> When I run top after my server has been running for a few days, Mysql
> is using 60 or 70MB of memory. When I restart mysql, it goes back to
> 3000. Any idea where I should start to look for a problem? What
> causes this?

What are your mysql memory settings?  70MB may be low for all we know.
It's definitely low for my machines :) And what units are "3000" in? 
KB can't be right, since mysql will always take more than 3MB of
memory.  Important settings include:

key_buffer
sort_buffer_size
read_buffer_size
read_rnd_buffer_size
myisam_sort_buffer_size
thread_cache
query_cache_size

-- 
	Dan Nelson
	dnelson@stripped
Thread
Memory problemsDoug Wolfgram6 Oct
  • Re: Memory problemsDan Nelson6 Oct
Re: Memory problemsDan Nelson6 Oct