From: 张斌 (skxiaonangmail.com)
Date: Fri Oct 17 2008 - 10:26:00 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

2008/10/17 bruce <bedouglasearthlink.net>

> 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:dnelsonallantgroup.com]
> Sent: Friday, October 17, 2008 7:59 AM
> To: Marten Lehmann
> Cc: mysqllists.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
> dnelsonallantgroup.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=bedouglasearthlink.net
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=skxiaonangmail.com
>
>

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]