I've read a lot of articles about Isolation levels, but I'm confused which one to choose for my MySQL 5.6 database.
This is my situation:
Let's say I have two group of users:
- Group A (executes selects)
- Group B (executes inserts and updates)
Every individual in group A is executing huge select query that takes 5 minutes and in the meanwhile a couple members from group B are inserting and updating records.
Which database isolation do I need to achieve:
- The select queries that are executed by people from Group A should NOT cause a lock to eachother. So simultaneously reads should be allowed, they must be able to access the same data at the same time.
- The select queries that are executed by people from Group A should NOT cause a lock to people from Group B who are inserting and updating. So simultaneously writes and reads should be allowed and people from Group B shouldn't be waiting 5 minutes until the individual select queries from Group A are finished.
- The inserted and updated records should be included in the select query results from Group A.