hi ron. forgive me, so running mulitple instances of mysql (the client) will bounce between dual processors???
hmmmm... i'll check it out. never really thought about how to test this, thanks.. -----Original Message----- From: Dan Nelson [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2008 8:41 AM To: bruce Cc: 'Marten Lehmann'; mysql@lists.mysql.com Subject: Re: MySQL und dual cores In the last episode (Oct 17), bruce said: > From: Dan Nelson > > 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. > > a sa short test, how would one demonstrate this from the cli.., using the > mysql cmd interface?? I thought that's exactly what I explained how to do :) Run the "mysql" command in two terminal windows (or screen sessions, or vtys, or whatever you prefer) and "top" in a third. -- 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]
