qkl_librarys;
+--------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+--------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| qkl_librarys | 0 | PRIMARY | 1 | id | A | 39747 | NULL | NULL | | BTREE | |
+--------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------++--------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+---------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| title | varchar(100) | NO | | NULL | |
| en_title | varchar(100) | YES | | NULL | |
| lasttime | int(11) | YES | | NULL | |
+--------------+---------------+------+-----+---------+----------------+
、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、
+----------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+---------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| mid | int(11) | NO | | NULL | |
| thunder | text | YES | | NULL | |
+----------+---------+------+-----+---------+----------------++--------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+--------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| qkl_libdowns | 0 | PRIMARY | 1 | id | A | 39747 | NULL | NULL | | BTREE | |
+--------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| qkl_libmore | 0 | PRIMARY | 1 | id | A | 31264 | NULL | NULL | | BTREE | |
+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------++--------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| mid | int(11) | NO | | NULL | |
| push | tinyint(4) | YES | | NULL | |
+--------------+--------------+------+-----+---------+----------------+按这贴http://bbs.csdn.net/posts/395605274的方法加了索引后
给加了索引后发现更新非常慢 查询也少有变慢 如何解决
+--------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+--------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| qkl_librarys | 0 | PRIMARY | 1 | id | A | 39747 | NULL | NULL | | BTREE | |
+--------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------++--------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+---------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| title | varchar(100) | NO | | NULL | |
| en_title | varchar(100) | YES | | NULL | |
| lasttime | int(11) | YES | | NULL | |
+--------------+---------------+------+-----+---------+----------------+
、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、
+----------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+---------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| mid | int(11) | NO | | NULL | |
| thunder | text | YES | | NULL | |
+----------+---------+------+-----+---------+----------------++--------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+--------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| qkl_libdowns | 0 | PRIMARY | 1 | id | A | 39747 | NULL | NULL | | BTREE | |
+--------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| qkl_libmore | 0 | PRIMARY | 1 | id | A | 31264 | NULL | NULL | | BTREE | |
+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------++--------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| mid | int(11) | NO | | NULL | |
| push | tinyint(4) | YES | | NULL | |
+--------------+--------------+------+-----+---------+----------------+按这贴http://bbs.csdn.net/posts/395605274的方法加了索引后
给加了索引后发现更新非常慢 查询也少有变慢 如何解决
解决方案 »
- mysqldump不锁表备份,怎么设置为好?
- 删除数据时提示#1030 - Got error -1 from storage engine
- MySql高手请进——关于如何导入MySql
- 十万火急!!!求助:windows下Mysql触发器的问题
- 最近刚看mysql,对于产生无重复编号算法有个想法,我用伪码表示,各位看看执行效率和空间存储效率怎么样
- mysql和struts写的java程序,插入时乱码,太头疼了。有知道怎么做的谢谢给说一声。
- 来个难度大点的,如何从csv更新“部分”数据到数据表?原数据表有内容
- mysql中numric类型的运算
- 两站表,三个关联,从其中查询出每个政府下的合作社和合作社社员数量!给分50!
- 求助高手:区间命中后更新的优化算法
- 问一下mysql在64位win7系统导出的数据库文件能导入win7的32位系统吗?
- mysql
应该是条件没有写好