hi... a sa short test, how would one demonstrate this from the cli.., using the mysql cmd interface??
thanks -----Original Message----- From: Dan Nelson [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2008 7:59 AM To: Marten Lehmann Cc: mysql@lists.mysql.com Subject: Re: MySQL und dual cores 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. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
