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'll
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
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 concurrency control, but i guess this between
transactions
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,
not queries.
Consider