List:Internals« Previous MessageNext Message »
From:Shawn Green (MySQL) Date:November 18 2011 9:26pm
Subject:Re: Concurrent table access from InnoDB
View as plain text  
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
Thread
Concurrent table access from InnoDBhwatari18 Nov
  • Re: Concurrent table access from InnoDBMySQL)18 Nov
    • Re: Concurrent table access from InnoDBRick James18 Nov
      • Re: Concurrent table access from InnoDBMySQL)18 Nov
        • Re: Concurrent table access from InnoDBHiromichi Watari19 Nov
          • Re: Concurrent table access from InnoDBMark Leith21 Nov
            • Re: Concurrent table access from InnoDBStewart Smith22 Nov
              • Re: Concurrent table access from InnoDBRick James22 Nov
                • Re: Concurrent table access from InnoDBHiromichi Watari22 Nov
                  • Re: Concurrent table access from InnoDBRick James22 Nov
                    • Re: Concurrent table access from InnoDBHiromichi Watari23 Nov
RE: Concurrent table access from InnoDBSteve Hardy21 Nov