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
