List:General Discussion« Previous MessageNext Message »
From:bruce Date:October 17 2008 5:25pm
Subject:RE: MySQL und dual cores
View as plain text  
hey martin...


thanks, and this is different.. someone else replied that alll i had to do,
was to start two sessions of mysql in different xterm windows, and i'd be
using both processesors. and that didn't sound right..


-----Original Message-----
From: Martin Gainty [mailto:mgainty@stripped]
Sent: Friday, October 17, 2008 10:12 AM
To: bruce; 'Dan Nelson'
Cc: 'Marten Lehmann'; mysql@stripped
Subject: RE: MySQL und dual cores


need to specify processor with 'taskset'

windows specific hacky workaround
http://blogs.techrepublic.com.com/programming-and-development/?p=691

Under linux you can set the task processor affinity with taskset
http://www.cyberciti.biz/tips/setting-processor-affinity-certain-task-or-pro
cess.html

Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official
business of Sender. This transmission is of a confidential nature and Sender
does not endorse distribution to any party other than intended recipient.
Sender does not necessarily endorse content contained within this
transmission.


> From: bedouglas@stripped
> To: dnelson@stripped
> CC: lehmann@stripped; mysql@stripped
> Subject: RE: MySQL und dual cores
> Date: Fri, 17 Oct 2008 09:27:28 -0700
>
> 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
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>



You live life beyond your PC. So now Windows goes beyond your PC. See how

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