Ok,
So how do I optimize memory usage? Where to start ?
-Jon
-----Original Message-----
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 9:16 PM
To: Jon Shoberg
Cc: [EMAIL PROTECTED]
Subject: Re: .Optimize mySQL memory usage ? 41MB threads ??
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
[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
