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

-- 
	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