Well, let me say if that happens its because there is a logic mistake in your application. But you need to know and understand what happens in MySQL to be able to avoid the problem.  In short, the WHY of this article is to inform you about possible pitfalls and how to prevent them from [&]

https://www.percona.com/blog/what-if-mysqls-repeatable-reads-cause-you-to-lose-money/