通过配置AUTO_ID_CACHE = 1 实现了 非聚簇索引的自增id 的连续
Create Table: CREATE TABLE `data_630001t` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`flowid` bigint(20) DEFAULT NULL,
`dataid` bigint(20) DEFAULT NULL,
`thirdId` varchar(32) NOT NULL DEFAULT '',
`title` varchar(100) DEFAULT NULL,
`content` mediumtext DEFAULT NULL,
`source` int(11) DEFAULT NULL,
`url` varchar(128) DEFAULT NULL,
`deleted` int(11) DEFAULT NULL,
`ha3Data` mediumtext DEFAULT NULL,
`ctime` int(11) NOT NULL DEFAULT '0',
`utime` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`) /*T![clustered_index] NONCLUSTERED */,
KEY `thirdId` (`thirdId`),
KEY `idx_deleted` (`deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin /*T![auto_id_cache] AUTO_ID_CACHE=1 */
