How are the following situations handled in MySQL
UPDATEs and DELETEs will at very least apply a row level lock that prevents other transactions from affecting that row until the locking transaction is complete. If the LOCK takes 'too' long to resolve the transaction it can result in a TIMEOUT or a DEADLOCK scenario. Transactions are applied in a synchronous manner based upon when the command reaches the database.