On Thu, Sep 25, 2003 at 01:18:12PM -0700, Kevin wrote: > Hello, > > When I start mysql, the processlist shows 10 processes: > > Ps aux | grep mysql | wc -l > 10 > > But 'mytop' (handy command line utility to see processes) shows only the > number of threads I'm using. > > Anyone know why its using 10 processes if it only has 1 thread? I'm not > familiar with how 'ps' tries to report on threads (since mysql > technically supposedly has only 1 process). Is it doing something > wrong?
MySQL has a few threads that don't interact directly with clients. Are you using InnoDB? It adds a few more. > My main concern is for the reported memory usage. If ps is right, and > it IS using that memory, what is it doing? > > 1 31454 mysql 23M 2.1M 108M 23M 34819 S mysqld > 2 31456 mysql 23M 2.1M 108M 23M 34819 S mysqld > .. continue until .. > 29 31639 mysql 23M 2.1M 108M 23M 34819 S mysqld > 30 31709 mysql 23M 2.1M 108M 23M 34819 S mysqld They're threads. The memory is shared among them. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 11 days, processed 433,239,956 queries (422/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]