On Thu, Sep 11, 2003 at 11:30:20AM -0700, Mark Kaufer wrote:
> > By the way, Jeremy's original answer was more correct than mine, because
> > he noted where I did not that the sort buffer is a per-client resource
> > and is allocated once for each client -- or at least for each client that
> > issu
fer [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 11:30 AM
To: [EMAIL PROTECTED]
Subject: Re: my.cnf memory specifications
> By the way, Jeremy's original answer was more correct than mine,
because
> he noted where I did not that the sort buffer is a per-client resource
>
> By the way, Jeremy's original answer was more correct than mine, because
> he noted where I did not that the sort buffer is a per-client resource
> and is allocated once for each client -- or at least for each client that
> issues queries requiringn sorting, such as those with ORDER BY clauses.
At 10:17 AM -0700 9/11/03, Jeremy Zawodny wrote:
On Thu, Sep 11, 2003 at 12:06:23PM -0500, Paul DuBois wrote:
Linux reports the threads of a process as processes. You really only
have one process, with 31 threads. (Probably because a bunch of clients
have connected.) So your resources are sha
On Thu, Sep 11, 2003 at 12:06:23PM -0500, Paul DuBois wrote:
>
> Linux reports the threads of a process as processes. You really only
> have one process, with 31 threads. (Probably because a bunch of clients
> have connected.) So your resources are shared among the threads of
> the server proce
On Thu, Sep 11, 2003 at 09:29:27AM -0700, Mark Kaufer wrote:
> I've looked and looked but really can't find an answer to this question.
> In my my.cnf file, these are some of the things that are specified in
> [mysqld]:
>
> set-variable = key_buffer=256M
> set-variable = table_cache=64
> set-varia
At 9:29 AM -0700 9/11/03, Mark Kaufer wrote:
I've looked and looked but really can't find an answer to this question.
In my my.cnf file, these are some of the things that are specified in
[mysqld]:
set-variable = key_buffer=256M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-vari
