Seems like MERGE and PARTITION would be easy candidates for parallelism
(at least when scanning the partitions).
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
> 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: