Why are int and uint stored in little-endian format in the new row format of TiDB 4.0?

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: TiDB 4.0的新行格式里,int和uint为什么要用小端存储?

| username: TiDBer_624bnLjH

To improve efficiency, please provide the following information. Clear problem descriptions can be resolved more quickly:
【TiDB Usage Environment】Production, Testing, Research
【TiDB Version】4.0
【Encountered Problem】In the new row format of TiDB 4.0, why are int and uint stored in little-endian format? The old format used big-endian storage. What considerations were there for switching to little-endian?
【Reproduction Path】What operations were performed that led to the problem
【Problem Phenomenon and Impact】

| username: xfworld | Original post link

What is little-endian storage? What is big-endian storage?

| username: undefined | Original post link

It should be that x86 CPUs are normally in little-endian mode, right?