![](https://i-blog.csdnimg.cn/blog_migrate/75cbd0a000a106577f67345d7073e879.png)
产生测试文件
测试文件部分内容如下:
![731047-20161216151813745-1715031526.png](https://i-blog.csdnimg.cn/blog_migrate/873b645bd37db3b3680dd04a4f5f97cb.png)
产生测试文件代码:
package foo;
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.Date;
public class WriteIBdata {
public static void main(String[] args) {
String file = "C:\\linliu\\ib666";
writeFile(file);
}
public static void writeFile(String fileName) {
try {
FileWriter fw = new FileWriter(new File(fileName));
for (int i = 0; i < 10000 * 1500; i++) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
fw.write("'");
fw.write(sdf.format(new Date()));
fw.write("'");
fw.write(",");
fw.write("'");
fw.write(String.valueOf(System.nanoTime()));
fw.write("'");
fw.write(",");
fw.write("'");
fw.write("aaaaaaaaaaaaaaaaaaaa");
fw.write("'");
fw.write("\n");
if (i % 50000 == 0) {
System.out.println("Finish:" + i/50000);
}
}
fw.close();
} catch (IOException e1) {
}
}
}
测试Mysql数据库
创建数据表
CREATE TABLE `loadtable` (
`insertTstamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`logType` varchar(64) NOT NULL,
`content` varchar(64) NOT NULL,
PRIMARY KEY (`insertTstamp`,`logType`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
![](https://i-blog.csdnimg.cn/blog_migrate/718f67688af23afa7325d003355fea15.png)
![](https://i-blog.csdnimg.cn/blog_migrate/54cb9f6c82f18a130536a2c13ddd151d.png)
导入数据
load data infile '/home/testFile916M' into table loadtable fields terminated by ',' enclosed by '\'';
![](https://i-blog.csdnimg.cn/blog_migrate/ed51244a628760a089c9ba6b82b58a37.png)
查看入库情况:
![](https://i-blog.csdnimg.cn/blog_migrate/f0b2d7aa1056ddaa2ebd0a22cea37f4c.png)
另外的入库数据:
![](https://i-blog.csdnimg.cn/blog_migrate/aa0928f9bd195524e5daa7900b9e4e2c.png)
测试Infobright数据库
创建数据表
CREATE TABLE `loadtable` (
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`type` varchar(64) NOT NULL,
`content` varchar(64) NOT NULL
) ENGINE=BRIGHTHOUSE DEFAULT CHARSET=utf8;
![731047-20161216151816479-1217698539.png](https://i-blog.csdnimg.cn/blog_migrate/66cd1ce9b7a8b9bc82816fc796154513.png)
导入数据
load data infile '/home/ib916M' into table loadtable fields terminated by ',' enclosed by '\'';
![731047-20161216151816933-597323624.png](https://i-blog.csdnimg.cn/blog_migrate/3326203966875532ea4ad93e9425edbe.png)
查看入库结果:
![731047-20161216151817354-605851486.png](https://i-blog.csdnimg.cn/blog_migrate/c9e93ea6dd30fc6d7595150ab3e2ba46.png)
另外的入库数据:
![731047-20161216151817698-1774160832.png](https://i-blog.csdnimg.cn/blog_migrate/3fe09f890d6c9c8324c76f0cd6d48902.png)
总结
- mysql入库:1500万条数据,约900M,入库时间大约在5min左右;
- Infobright入库:1500万条数据,约900M,入库时间大约在2~3min左右;