In the last episode (Oct 07), Jon Shoberg said: > From: Dan Nelson [mailto:[EMAIL PROTECTED]] > > 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 [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php