如何提高Mysql语句插入性能
在表中已有大量的index的情况下插入大量数据，可以采用先将索引删除，然后再插入数据，然后再重新建立索引。之所以这样会快是因为？？？
7.2.14 Speed of INSERT Statements
The time to insert a record is determined by the following factors, where the numbers indicate approximate proportions:
* Connecting: (3)
* Sending query to server: (2)
* Parsing query: (2)
* Inserting record: (1 x size of record)
* Inserting indexes: (1 x number of indexes)
* Closing: (1)
This does not take into consideration the initial overhead to open tables, which is done once for each concurrently running query.
The size of the table slows down the insertion of indexes by log N, assuming B-tree indexes.
You can use the following methods to speed up inserts:
* If you are inserting many rows from the same client at the same time, use INSERT statements with multiple VALUES lists to insert several rows at a time. This is much faster (many times faster in some cases) than using separate single-row INSERT statements. If you are adding data to a non-empty table, you may tune the bulk_insert_buffer_size variable to make it even faster. See section 5.2.3 Server System Variables.
* If you are inserting a lot of rows from different clients, you can get higher speed by using the INSERT DELAYED statement. See section 14.1.4 INSERT Syntax.
* With MyISAM tables you can insert rows at the same time that SELECT statements are running if there are no deleted rows in the tables.
* When loading a table from a text file, use LOAD DATA INFILE. This is usually 20 times faster than using a lot of INSERT statements. See section 14.1.5 LOAD DATA INFILE Syntax.
* With some extra work, it is possible to make LOAD DATA INFILE run even faster when the table has many indexes. Use the following pr
相关文档：
Wordpress用了这么长时间，偶尔会想起来备份下数据，上次是用wp的xml，这次把自己机器的环境配的跟主机提供商基本一样了，正好那边有mysql数据库打包备份的服务，就尝试了一下。可不管我下载哪个时间点的备份包，里面都只有wp表的10个frm文件，copy到我的数据库目录后访问web，没有任何数据！直接搞不懂了。以前觉得用mysql ......
首先需要卸载redhat自带的mysql数据库（不然安装时会出问题）
rpm -qa|grep mysql
然后 rpm -e 包名称
如果涉及到依赖，就先删除依赖，或者加个 -nodeps 参数忽略依赖
有网友说用yum -y remove mysql也可以
另一个解决方法时在linux自带mysql基础上再装新的mysql
二进制安装包版本很多，常用的就两个，我下的是 ......
SQL #1: select * from uchome_feed where uid in('0',501...) order by dateline desc limit 0,50;
SQL #2: select * from uchome_feed where uid in(0,501...) order by dateline desc limit 0,50;
SQL #1 是CSDN 个人空间获取个人动态的SQL，属UCH原版SQL。
SQL #2 是去掉单引号(SQL #1中红色部分)后的SQL，两� ......
Oracle函数和mysql函数比较
1. Oracle中的to_number()转换成数字；
Oracle> Select to_number(‘123’) from dual; ----- 123;
&nbs ......
