hey martin...
thanks, and this is different.. someone else replied that alll i had to do, was to start two sessions of mysql in different xterm windows, and i'd be using both processesors. and that didn't sound right.. -----Original Message----- From: Martin Gainty [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2008 10:12 AM To: bruce; 'Dan Nelson' Cc: 'Marten Lehmann'; mysql@lists.mysql.com Subject: RE: MySQL und dual cores need to specify processor with 'taskset' windows specific hacky workaround http://blogs.techrepublic.com.com/programming-and-development/?p=691 Under linux you can set the task processor affinity with taskset http://www.cyberciti.biz/tips/setting-processor-affinity-certain-task-or-pro cess.html Martin ______________________________________________ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > CC: [EMAIL PROTECTED]; mysql@lists.mysql.com > Subject: RE: MySQL und dual cores > Date: Fri, 17 Oct 2008 09:27:28 -0700 > > 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] > You live life beyond your PC. So now Windows goes beyond your PC. See how -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
