Read transaction changes

Question

Regardless of the changes made to the MySQL database, are these changes readable in a single transaction? Or should I commit the transaction to read the changes?

I could easily check that out. But the question in SO raises a lot of good suggestions. Thanks for any input.

Answer 1

Assuming you are using InnoDB, the answer to your first question is usually yes, meaning that the answer to your second is usually no.

By default, MySQL InnoDB uses the sequential non-blocking read method :

, , . , , .

, , . , .

InnoDB - .