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>
