How many K does TiDB read and write in a single IO, i.e., what is the IO unit?

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

Original topic: tidb一次IO读写多少K,即IO单位是多少

| username: wenyi

What is the data read/write size per disk operation in TiDB? For example, Oracle uses 8K, MySQL uses 16K, so what is the IO read/write unit size in TiDB?

| username: WalterWj | Original post link

The image you provided is not accessible. Please provide the text content for translation.

| username: zhanggame1 | Original post link

TiKV Configuration File Description | PingCAP Documentation Center

| username: tidb狂热爱好者 | Original post link

Default 64k

| username: wangccsy | Original post link

The default value of 64K is still much larger than other databases.

| username: oceanzhang | Original post link

This value is very large and can easily cause write failures.

| username: vincentLi | Original post link

How do you measure the quality of block size? Is it better if it’s larger? Why does Oracle only need 8k?

| username: 哈喽沃德 | Original post link

It will be as large as you set it.

| username: dba远航 | Original post link

3rd Floor: Correct.

| username: 春风十里 | Original post link

AI misled me, I thought it was 64k, but the official documentation says 32k.

| username: 哈喽沃德 | Original post link

You can’t rely entirely on AI.

| username: zhanggame1 | Original post link

Just refer to the official documentation, and make sure to check the version number, as different versions may not be the same.

| username: 江湖故人 | Original post link

What kind of AI is this?

| username: 江湖故人 | Original post link

I checked the old version, and it is indeed 64KB.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.