Concurrency Control: How It Really Works
http://forge.mysql.com/wiki/Concurrency_Control:_How_It_Really_Works
This Thursday (September 24th, 14:00 UTC (yes, 1 h later than usually)),
Heikki Tuuri, the father of InnoDB, will give a session on Concurrency
Control: How It Really Works. He
In the last episode (May 19), Khaled Elmeleegy said:
> How does MySQL handle concurrency control between two or more concurrent
> quires (not transactions), on their website they say they use
> multi-versioned concurrency control, but i guess this between transactions,
>
Elmeleegy" <[EMAIL PROTECTED]>
收件者: <[EMAIL PROTECTED]>
傳送日期: 2002年5月20日 PM 12:36
主旨: Concurrency control
> How does MySQL handle concurrency control between two or more concurrent
> quires (not transactions), on their website they say they use
> multi-versioned
How does MySQL handle concurrency control between two or more concurrent
quires (not transactions), on their website they say they use
multi-versioned concurrency control, but i guess this between transactions,
not queries.
Consider the case we have two queries
Q1: select * from table1 EXCEPT