sorry.. my bad,
i was looking for the exact sequence of cmds that i could type in, in order to test this!!... sorry for the confusion.. thanks -----Original Message----- From: ?? [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2008 8:26 AM To: bruce Cc: Dan Nelson; Marten Lehmann; mysql@lists.mysql.com Subject: Re: MySQL und dual cores 2008/10/17 bruce <[EMAIL PROTECTED]> > hi... > > a sa short test, how would one demonstrate this from the cli.., using the > mysql cmd interface?? > Right, you also can use it in other editor,such as mysql-front editor or sql server > > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
