AUTO_INCREMENT & Rocksdb + Partition

 CREATE TABLE `ts_date_by_server` (

  `id` bigint(20) NOT NULL AUTO_INCREMENT,

  `id_mysql_server` int(11) NOT NULL,

  `id_ts_file` int(11) NOT NULL,

  `date` datetime NOT NULL,

  PRIMARY KEY (`id`,`date`),

  UNIQUE KEY `id_mysql_server` (`id_mysql_server`,`id_ts_file`,`date`)

) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT

 PARTITION BY RANGE (to_days(`date`))

(PARTITION `p737840` VALUES LESS THAN (737840) ENGINE = ROCKSDB,

 PARTITION `p737841` VALUES LESS THAN (737841) ENGINE = ROCKSDB);

while(true)

{

INSERT INTO `ts_date_by_server` (`id_mysql_server`,`id_ts_file`, `date`) VALUES (1, 3, '2020-02-19 16:06:05'),

(9, 3, '2020-02-19 16:06:05'),

(115, 3, '2020-02-19 16:06:05'),

(183, 3, '2020-02-19 16:06:05'),

(176, 3, '2020-02-19 16:06:05'),

(174, 3, '2020-02-19 16:06:05'),

(172, 3, '2020-02-19 16:06:05'),

(179, 3, '2020-02-19 16:06:05'),

(173, 3, '2020-02-19 16:06:05'),

(181, 3, '2020-02-19 16:06:05'),

(178, 3, '2020-02-19 16:06:05'),

(187, 3, '2020-02-19 16:06:05'),

(114, 3, '2020-02-19 16:06:05'),

(184, 3, '2020-02-19 16:06:05'),

(186, 3, '2020-02-19 16:06:05'),

(180, 3, '2020-02-19 16:06:05'),

(185, 3, '2020-02-19 16:06:05'),

(177, 3, '2020-02-19 16:06:05'),

(175, 3, '2020-02-19 16:06:05'),

(171, 3, '2020-02-19 16:06:05'),

(182, 3, '2020-02-19 16:06:05');

}

[2020-02-19 16:08:18]  [SHOW WARNINGS] 

SELECT 

  * 

FROM 

  `sys`.`schema_auto_increment_columns` 

LIMIT 

  200

/data/www/pmacontrol/vendor/glial/glial/Glial/Sgbd/Sql/Mysql/Mysql.php:419

+-----------+--------+-------------------------------------------------------------------------------+

|  Level    |  Code  |  Message                                                                      |

+-----------+--------+-------------------------------------------------------------------------------+

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

|  Warning  |  1916  |  Got overflow when converting '18446744073709551615' to INT. Value truncated  |

+-----------+--------+-------------------------------------------------------------------------------+

28 rows

MariaDB [pmacontrol]> select max(id) from ts_date_by_server;

+---------+

| max(id) |

+---------+

|  155962 |

+---------+

1 row in set (0.001 sec)

MariaDB [pmacontrol]> ALTER TABLE `ts_date_by_server` AUTO_INCREMENT=155963;

Query OK, 0 rows affected (0.006 sec)

Records: 0  Duplicates: 0  Warnings: 0