请求各位专家，我的数据快转换后怎么还是这样？

enhand · 发表于 2009-6-3 06:53:14

我从DZ5.5转到6.0后，和DZ7.0比较发现有很多索引，请问专家哪些可以删除啊！

谢谢了！

1、这是我现在的情况：

mysql> show index from cdb_threads;
+-------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+
| cdb_threads | 0 | PRIMARY | 1 | tid | A | 181736 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | lastpost | 1 | displayorder | A | 5 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | lastpost | 2 | lastpost | A | 181736 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | lastpost | 3 | fid | A | 181736 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | dateline | 1 | displayorder | A | 5 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | dateline | 2 | dateline | A | 181736 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | dateline | 3 | fid | A | 181736 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | displayorder | 1 | fid | A | 79 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | displayorder | 2 | displayorder | A | 149 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | displayorder | 3 | lastpost | A | 181736 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | typeid | 1 | fid | A | 79 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | typeid | 2 | typeid | A | 754 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | typeid | 3 | displayorder | A | 857 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | typeid | 4 | lastpost | A | 181736 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | sgid | 1 | fid | A | 79 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | sgid | 2 | sgid | A | 83 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | fid | 1 | fid | A | 79 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | fid | 2 | lastpost | A | 181736 | NULL | NULL | | BTREE | |
+-------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+
18 rows in set (0.00 sec)

复制代码

这是DZ7.0的表结构

mysql> show index from cdb_threads;
+-------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+
| cdb_threads | 0 | PRIMARY | 1 | tid | A | 82 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | digest | 1 | digest | A | 1 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | sortid | 1 | sortid | A | 1 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | displayorder | 1 | fid | A | 11 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | displayorder | 2 | displayorder | A | 13 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | displayorder | 3 | lastpost | A | 82 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | typeid | 1 | fid | A | 11 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | typeid | 2 | typeid | A | 11 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | typeid | 3 | displayorder | A | 13 | NULL | NULL | | BTREE | |
| cdb_threads | 1 | typeid | 4 | lastpost | A | 82 | NULL | NULL | | BTREE | |
+-------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+
10 rows in set (0.00 sec)
mysql> show index from cdb_posts;
+-----------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-----------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| cdb_posts | 0 | PRIMARY | 1 | pid | A | 143 | NULL | NULL | | BTREE | |
| cdb_posts | 1 | fid | 1 | fid | A | 11 | NULL | NULL | | BTREE | |
| cdb_posts | 1 | authorid | 1 | authorid | A | 28 | NULL | NULL | | BTREE | |
| cdb_posts | 1 | dateline | 1 | dateline | A | 143 | NULL | NULL | | BTREE | |
| cdb_posts | 1 | invisible | 1 | invisible | A | 1 | NULL | NULL | | BTREE | |
| cdb_posts | 1 | displayorder | 1 | tid | A | 71 | NULL | NULL | | BTREE | |
| cdb_posts | 1 | displayorder | 2 | invisible | A | 71 | NULL | NULL | | BTREE | |
| cdb_posts | 1 | displayorder | 3 | dateline | A | 143 | NULL | NULL | | BTREE | |
| cdb_posts | 1 | first | 1 | tid | A | 71 | NULL | NULL | | BTREE | |
| cdb_posts | 1 | first | 2 | first | A | 143 | NULL | NULL | | BTREE | |
+-----------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
10 rows in set (0.00 sec)

复制代码

我的表结构明显复杂的多，请问专家能否删除一部分索引？？

幸福在右 · 发表于 2009-6-3 07:58:28

dz 5.0 升级到 dz 6.0 即可

如果需要升级到 7.0 再升级到 7.0 即可。

enhand · 发表于 2009-6-3 09:46:12

不过升级以后出现了很多莫名奇妙的索引，有没有一种办法可以重新建立索引？？

桃子(小敏) · 发表于 2009-6-3 09:58:18

Discuz!7.0和6.0比较数据库结构不一样，索引肯定也不一样的

pc77maikongjian · 发表于 2009-6-3 10:02:14

版本之间的数据库结构不一致索引不一样

damyankee · 发表于 2009-6-3 14:53:33

很混乱的，

蓝豆 · 发表于 2009-6-3 22:08:42

楼上的请不要灌水

		自动登录	找回密码
密码			立即注册

[已解决] 请求各位专家，我的数据快转换后怎么还是这样？