Since two-phase commit (2PC) does not guarantee data consistency, what is the point of existence?

such as the title.
even if it can reduce data inconsistencies, it cannot be completely eliminated.

Is there any other way to compensate for

? Or what?

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-1e97797-165b.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-1e97797-165b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?