At 19:44 -0800 2/17/05, Matt Florido wrote:
>Paul DuBois wrote:
>>At 19:21 -0800 2/17/05, Matt Florido wrote:
>>>I'm wondering if anyone can provide any tips as to how to conserve
>>>resources. Currently, I see 10 instances of mysqld running. Each
>>>instance is approximately 18MB. For my application of MySQL, I
>>>don't require a large amount of resources allocated to mysqld.
>>If you're running Linux, there's nothing to optimize here. These are
>>threads of the same process, not 10 different processes.
>Paul, thanks for the fast response.
>Ah...so this is ignorance on my part. You're saying mysqld is not
>running separate processes even though Top reports separate PID.
>Instead of each "thread" consuming appx. 18MB, the entire process is
>consuming just 18MB?
Yes, that's right.
On my Linux box, I typically have several versions of MySQL running.
Right now there are 249 mysqld processes, but I certainly don't have
249 servers going all at once. It's really only 21.
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com