- Outside a transaction, run
SHOW transaction_isolation;. What is the default level? - Start a transaction at
REPEATABLE READ. Then show its level. - End that transaction. Start a new one, run
SELECT * FROM accounts;, then try to set the level toSERIALIZABLE. What mustSET TRANSACTIONcome before? End the aborted transaction. - Start a transaction at
SERIALIZABLEthe right way and show its level. - A MySQL server runs with the default settings. Which isolation level does a new transaction get?