Why does MySQL produce dirty reading?

consult data:
1. MySQL transactions are isolated, and the intermediate state in the transaction process is not visible;
2. MySQL dirty reading means that a transaction is making changes to a record, and the data of this record is in an inconsistent state before the transaction is completed and committed. At this point, another transaction also reads the same record, and if uncontrolled, the second transaction reads these "dirty" data and makes further processing accordingly, resulting in uncommitted data dependencies.

the question is:
since transactions are isolated, how can you read "dirty" data that other transactions have not committed?

Transaction mysql

Mar.03,2021

this involves the level of isolation of things. The higher the isolation level, the better the integrity and consistency of the data, but the greater the impact on concurrency performance

                             
read-uncommitted                        
read-committed                        
repeatable-read                         
serializable

Previous: Data writing of antdesign

Next: The browser did not update the script when Flask modified the js script to restart the web service, which is why

Tp5 database transaction rollback problem
I test with the simplest code, opens the transaction, inserts data, and rolls back . but the database still inserts new data . my database type is InnoDB so I wonder if that s what it says in the document, pay attention to make sure your dat...

Transaction mysql thinkphp5 php

Sep.01,2021
Yii2.0 operates transactions with multiple databases
I am like this now. The project has a lot of databases, all under the same mysql server, and there is db,db2,db3 in main.php. Now there is a storage operation like this. Table A comes from db2,B table and comes from db3,. When using transactions, it is ...

Transaction mysql yii2 php

Oct.23,2021
Is the rollback of the transaction a failure of sql execution or will it be rolled back if the number of affected rows is 0?
is the rollback of the transaction a failure of sql execution or a success of sql execution, but will be rolled back if the number of rows affected by additions, deletions and changes is 0? ...

Transaction mysql sql

Apr.18,2022

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e97810-463a5.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e97810-463a5.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?