In the last episode (Oct 17), Marten Lehmann said:
> 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?
Each thread of a threaded process can run on a different CPU. Try
connecting to mysql over two sessions and run "SELECT
BENCHMARK(10000000000,1+1);" on both. If you switch to top you should
see mysqld go to 200% CPU.