MySQL und dual cores

[Marten Lehmann]

Hello,

we are using MySQL 4.1 and 5 on AMD dual core processors, but I can only 
see one mysqld process on each machine. Since a process is always tied 
to a certain processor, mysqld doesn't seem to make use of the second 
core. As far as I know multiple threads of one process would be visible 
as different processes using the ps command.

Is mysqld really not using more than one processor core? Or if it does, 
then how can I verify it?

Regards
Marten