Re: Concurrent table access from InnoDB

Hello Hiromichi,

On 11/17/2011 20:42, [email protected] 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

-- 
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe:    http://lists.mysql.com/[email protected]