Re: Concurrent table access from InnoDB

[Shawn Green (MySQL)]

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.
-- 
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN