最近发现一个表的自增列有跳号现象
查看官方文档 上面说
If transactions continue to access sequence numbers during an export, sequencenumbers can be skipped. The best way to ensure that sequence numbers are not skipped is to ensure that the sequences are not accessed during the export.
Sequence numbers can be skipped only when cached sequence numbers are in use.
When a cache of sequence numbers has been allocated, they are available for use in the current database. The exported value is the next sequence number (after the cached values). Sequence numbers that are cached, but unused, are lost when the sequence is imported
我理解的意思是
如果再export的时候有sequences 被accessed ,就会发上跳号
可是不是很理解这个他是怎么做到的
我应该如果避免呀 7*24的系统