mysql iot 主键自增列问题

mysql 如何避免热点块？

主键按sn自增列

Oracle 可以通过翻转索引 比如 插入101 102 103 104 变成101 201 301 401 分散数据

反转索引坏处,无法index range scan


mysql> Create Index TEST_INDEX_R On machine_info(sn) Reverse; 
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Reverse' at line 1
mysql> Create Index TEST_INDEX_R On machine_info(info) Reverse;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Reverse' at line 1
mysql>