> 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.
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-variable = max_connections=1000
set-variable = t
