136678436 2012-06-19 10:02:31 INFO: Table chris001.tab001 row size 80 bytes (base overhead 32 bytes, column id 4 bytes, column name 12 bytes, column memo 12 bytes, column num 8 bytes)
186966810 2012-06-19 10:03:21 INFO: Query chris001.'insert into tab001 values ( , , , )' compiled in 1825 miliseconds
194366714 2012-06-19 10:03:29 INFO: Query chris001.'select * from tab001' compiled in 712 miliseconds
283342115 2012-06-19 10:04:58 INFO: Query chris001.'select count(0) from tab001' compiled in 632 miliseconds
从以上测试我们看到，两次查询的首次和之后时间对比：
select * from tab001; (0.71 sec) (0.00 sec)
select count(0) from tab001; (0.63 sec) (0.00 sec)
从日志可以知道，首次查询的耗时基本全都花在编译上了 。
- 关闭
$ killall memsqld
4 总结
引用 MemSQL 网站的介绍
MemSQL 写道
MemSQL places data into memory and translates SQL into C++ for the utmost optimization in query execution. This enables MemSQL to write and read data at incredible speeds, and by offering a relational interface, you can unify the data you’d normally store in a short-lived medium—cache or key-value store—and place it directly into a database along with your existing data.
附： 软硬件要求
支持的部署环境，必须 64位
硬件：
Intel Core i3 or better processor
At least 8GB RAM
注：测试时RAM没有8G会有警告，不影响使用。