List:Internals« Previous MessageNext Message »
From:Rick James Date:December 7 2009 10:01pm
Subject:RE: is MySQL query execution single threaded?
View as plain text  
Seems like MERGE and PARTITION would be easy candidates for parallelism
(at least when scanning the partitions).

 
Rick James
MySQL Geeks - Consulting & Review

 

> -----Original Message-----
> From: Hartmut.Holzgraefe@stripped [mailto:Hartmut.Holzgraefe@stripped] 
> Sent: Monday, September 28, 2009 5:44 AM
> To: Zardosht Kasheff
> Cc: Konstantin Osipov; internals@stripped
> Subject: Re: is MySQL query execution single threaded?
> 
> Konstantin Osipov wrote:
> 
> > Currently one SQL statement runs from start to end in the same 
> > physical thread.
> 
> unless you query ndbcluster or federated tables, in this case
> part of the work is handed of to external processes and in the
> case of cluster several data nodes may process the low level
> storage engine API requests in parallel, each working on its
> active partition(s) of the data ...
> 
> But for the actual mysqld process it is true that all work it
> does on a certain query itself is performed by the same single
> thread.
> 
> -- 
> Hartmut Holzgraefe, MySQL Regional Support Manager, EMEA
> 
> Sun Microsystems GmbH, Sonnenallee 1, 85551 Kirchheim-Heimstetten
> Amtsgericht Muenchen: HRB161028
> Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel
> Vorsitzender des Aufsichtsrates: Martin Haering
> 
> -- 
> MySQL Internals Mailing List
> For list archives: http://lists.mysql.com/internals
> To unsubscribe:    
> http://lists.mysql.com/internals?unsub=1
> 
> 
Thread
is MySQL query execution single threaded?Zardosht Kasheff25 Sep
  • Re: is MySQL query execution single threaded?Konstantin Osipov25 Sep
    • Re: is MySQL query execution single threaded?Hartmut Holzgraefe28 Sep
      • RE: is MySQL query execution single threaded?Rick James2 Oct
      • RE: is MySQL query execution single threaded?Rick James7 Dec