List:Internals« Previous MessageNext Message »
From:Hartmut Holzgraefe Date:September 28 2009 12:43pm
Subject:Re: is MySQL query execution single threaded?
View as plain text  
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
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