i****c 发帖数: 102 | 1 我要往MYSQL里插入近10 million记录,
用的是MYSQL 5.0,JDBC用的是MYSQL官方提供的
我发现每插入一条记录
在终端都打出很长的mysql dubug详细信息
这是不是很影响速度?怎么样才能关掉呢?
20多个小时才插入了3 million 条记录
还有其他加快速度的方法吗?
谢谢 | y********o 发帖数: 2565 | 2 I googled, but not sure if it helps.
src:
http://scripts.webmastersite.net/wsnlinks/wsnmanual/articles/MySQL_errors-66.html
Note: If all else fails you can suppress MySQL warnings by setting your
debug level to "suppress errors." This is not advisable in most
circumstances, however, as the warning usually indicates a problem which
needs to be fixed.
| I******e 发帖数: 101 | 3 What is the error message you are seeing? |
|