Re: Concurrent table access from InnoDB

[Rick James]

Is this what keeps there from being parallelism in PARTITIONed tables?

On 11/18/11 1:26 PM, Shawn Green (MySQL) wrote:
> Hello Hiromichi,
>
> On 11/17/2011 20:42, hwatari@stripped wrote:
>>
>>
>>
>> Hi,
>> Is it possible for a client connection thread to access 2 tables concurrently
> from InnoDB, say using a slave thread ?  Or is access limited to one table at a time per
> client connection thread ?
>> Thanks,
>> Hiromichi
>>
> Each connection (client session) is only allowed to have one active
> command. That one command may affect multiple tables but there can only
> be one active command or its corresponding results on the connection at
> any one time.
>
> if one client needs to process the results of two or more commands in
> parallel, they need to open separate connections and execute those
> commands independently through each connection.

-- 
Rick James - MySQL Geek