What if the MySQL server crashes during an Insert or delete or update
statement, In what state would that leave the database, and would MySQL
recover? If so how would it do that?
If not what would happen, half of the statement would get executed before
the crash while the rest is not?
Would you pl
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 se
