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