From: Dan Nelson
Date: October 8 2002 2:51am
Subject: Re: .Optimize mySQL memory usage ? 41MB threads ??
List-Archive: http://lists.mysql.com/mysql/121572
Message-Id: <20021008025131.GA39947@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Oct 07), Jon Shoberg said:
> From: Dan Nelson [mailto:dnelson@stripped] 
> > In the last episode (Oct 07), Jon Shoberg said:
> > > I have a small PHP website that gets a fair amount of traffic. 
> > > It's a simple layout with two tables. I average about 50
> > > concurrently open apache sessions and 40 open mysql connections. 
> > > I am calling for persistent connections from the mySQL/PHP API.
> > > 
> > > But here is the kicker.  Each mySQL thread takes about 41mb!! :(
> > > Can anyone point me to resources on optimizing mySQL's memory
> > > usage under a moderate/heavy load?
> >  
> > Threads have no memory.  You're getting misled by Linuxes threads
> > implementation, which displays each thread as if it were a separate
> > process.  They actually share the same block of memory, which is
> > why they're threads and not processes.
> 
> So how do I optimize memory usage?  Where to start ?

Have you read the manual?  Chapter 5 pretty much covers everything. 
http://www.mysql.com/doc/en/MySQL_Optimisation.html
http://www.mysql.com/doc/en/Memory_use.html

-- 
	Dan Nelson
	dnelson@stripped