Read Committed Vs Repeatable Read
Read Committed Vs Repeatable Read . With less storage requirements, it may store more useful data in the buffer pool. Repeatable read is sufficient for your case. PPT Transactions PowerPoint Presentation, free download ID1414869 from www.slideserve.com The repeatable read isolation level provides a guarantee that data will not change for the life of the transaction once it has been read for the first time. This has confused me because i don't think changing isolation level to read committed would significantly impact query time. Repeatable read is mysql’s default transaction isolation level.