Re: Concurrent table access from InnoDB
Rick James <[email protected]>
| Newsgroups | gmane.comp.db.mysql.devel |
|---|---|
| Message-ID | <[email protected]> |
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, [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. -- Rick James - MySQL Geek -- MySQL Internals Mailing List For list archives: http://lists.mysql.com/internals To unsubscribe: http://lists.mysql.com/[email protected]