List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:October 17 2008 3:40pm
Subject:Re: MySQL und dual cores
View as plain text  
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
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