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 process.
Some versions of Linux act more like Solaris now. When I tested MySQL on RH9 using NPTL, I found that it reported a single process in top/ps/etc. That was a bit of a surprise...
A pleasant surprise! Thanks.
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.
Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 4 days, processed 156,290,200 queries (450/sec. avg)
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
