List:General Discussion« Previous MessageNext Message »
From:bruce Date:October 17 2008 3:10pm
Subject:RE: MySQL und dual cores
View as plain text  
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:dnelson@stripped]
Sent: Friday, October 17, 2008 7:59 AM
To: Marten Lehmann
Cc: mysql@stripped
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
	dnelson@stripped

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1

Thread
MySQL und dual coresMarten Lehmann17 Oct
  • Re: MySQL und dual coresDan Nelson17 Oct
    • RE: MySQL und dual coresbruce17 Oct
      • Re: MySQL und dual cores张斌17 Oct
        • RE: MySQL und dual coresbruce17 Oct
      • Re: MySQL und dual coresDan Nelson17 Oct
        • RE: MySQL und dual coresbruce17 Oct
RE: MySQL und dual coresbruce17 Oct