Which isolation level to use in a basic MySQL project?

I think you worry too much about the isolation level.

I think you worry too much about the isolation level. If you have multiple tables to update you need to do: START TRANSACTION; UPDATE table1 ....; UPDATE table2 ....; UPDATE table3 ....; COMMIT; This is the important stuff, the isolation level is just gravy. The default level of repeatable read will do just fine for you.

Note that select ... for update will lock the table, this can result in deadlocks, which is worse than the problem you may be trying to solve. Only use this if you are deleting rows in your DB. To be honest I rarely see rows being deleted in a DB, if you are just doing updates, then just use normal selects.

Anyway see: dev.mysql.com/doc/refman/5.0/en/innodb-t....

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.