-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
On Thu, 25 Sep 2003, Kevin wrote:
> When I start mysql, the processlist shows 10 processes:
>
> Ps aux | grep mysql | wc -l
> 10
On Linux (I assume this is what we're talking about here), threads are
shown as separate processes, too. On other OS'es you will only see one
mysqld process in the process table.
> But 'mytop' (handy command line utility to see processes) shows only the
> number of threads I'm using.
Yes, but only the threads that serve client requests. The MySQL daemon
spawns a few other helper threads as well (e.g. some for InnoDB, some for
replication). These are not shown in mytop, but the OS process list (if it
supports showing threads as well)
> 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?
No, you're all fine. No worries :)
> 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
That's the total number of memory for the mysqld process including all
it's threads - it's just being repeated for every thread.
Bye,
LenZ
- --
Lenz Grimmer <[EMAIL PROTECTED]>
Senior Production Engineer
MySQL GmbH, http://www.mysql.de/
Hamburg, Germany
For technical support contracts, visit https://order.mysql.com/?ref=mlgr
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)
Comment: For info see http://quantumlab.net/pine_privacy_guard/
iD8DBQE/c1kfSVDhKrJykfIRAmAeAJ9cvDKYQdOfqnScgN0HV68TTEb1wgCeNd8n
TBF7g3cUQMYewTjv1tdgHtY=
=5GT8
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
