From: Dan Nelson Date: October 6 2004 2:35am Subject: Re: Memory problems List-Archive: http://lists.mysql.com/mysql/173695 Message-Id: <20041006023511.GB3100@dan.emsphone.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii 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