mysql> CREATE TABLE t (a bigint AUTO_RANDOM, b varchar(255), PRIMARY KEY (a))
-> ;
Query OK, 0 rows affected, 1 warning (1.02 sec)
mysql> insert into t (b) values(‘1’);
Query OK, 1 row affected (0.02 sec)
mysql> insert into t (b) values(‘2’);
Query OK, 1 row affected (0.00 sec)
mysql> insert into t (b) values(‘3’);
Query OK, 1 row affected (0.00 sec)
mysql> insert into t (b) values(‘4’);
Query OK, 1 row affected (0.01 sec)
mysql> insert into t (b) values(‘5’);
Query OK, 1 row affected (0.00 sec)
mysql> select * from t;
±--------------------±-----+
| a | b |
±--------------------±-----+
| 2305843009213693957 | 5 |
| 2882303761517117442 | 2 |
| 5188146770730811393 | 1 |
| 5188146770730811396 | 4 |
| 7493989779944505347 | 3 |
±--------------------±-----+
5 rows in set (0.00 sec)
mysql> insert into t (b) values(‘6’);
Query OK, 1 row affected (0.00 sec)
mysql> insert into t (b) values(‘7’);
Query OK, 1 row affected (0.01 sec)
mysql> insert into t (b) values(‘8’);
Query OK, 1 row affected (0.01 sec)
mysql> select * from t;
±--------------------±-----+
| a | b |
±--------------------±-----+
| 2017612633061982216 | 8 |
| 2305843009213693957 | 5 |
| 2882303761517117442 | 2 |
| 3458764513820540935 | 7 |
| 5188146770730811393 | 1 |
| 5188146770730811396 | 4 |
| 5188146770730811398 | 6 |
| 7493989779944505347 | 3 |
±--------------------±-----+
8 rows in set (0.00 sec)
请问,auto_random是如何保证唯一性呢
若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。