List:Internals« Previous MessageNext Message »
From:Rick James Date:November 18 2011 9:29pm
Subject:Re: Concurrent table access from InnoDB
View as plain text  
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

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