List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:October 8 2002 2:51am
Subject:Re: .Optimize mySQL memory usage ? 41MB threads ??
View as plain text  
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
Thread
.Optimize mySQL memory usage ? 41MB threads ??Jon Shoberg8 Oct
  • Re: .Optimize mySQL memory usage ? 41MB threads ??Dan Nelson8 Oct
    • RE: .Optimize mySQL memory usage ? 41MB threads ??Jon Shoberg8 Oct
      • Re: .Optimize mySQL memory usage ? 41MB threads ??Dan Nelson8 Oct
      • RE: .Optimize mySQL memory usage ? 41MB threads ??root8 Oct