Do I need to adjust the AUTO_RANDOM_BASE initial value if it is too large?

Translated
1

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

Original topic: AUTO_RANDOM_BASE初始值过大需要调整吗

| username: otjoy

I found that the AUTO_RANDOM_BASE value of a table is too large, and I’m not sure if I should adjust it. Currently, it is /*T![auto_rand_base] AUTO_RANDOM_BASE=223372036854955950 */.
The official documentation says:
It is used to specify the initial value of the AutoRandom increment part. This parameter can be considered as part of the internal interface and should be ignored by users.

2
| username: 啦啦啦啦啦 | Original post link
  1. You can convert this value to binary and see, it’s actually not very large.
  2. No need to adjust, and it’s not recommended to adjust. Inappropriately assigning values explicitly may lead to the table prematurely exhausting the numbers used for automatic allocation.
3
| username: otjoy | Original post link

I want to know, how is such a large number generated? Does it mean that 223372036854955950 quotas have been consumed? Can it really be completely ignored?

4
| username: 啦啦啦啦啦 | Original post link

You can refer to this

5
| username: system | Original post link

This topic was automatically closed 1 minute after the last reply. No new replies are allowed.