[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_11":-5},"routes/user.$name.replies",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":16},"replies",[35],"user",{"_20":21,"_13":14,"_22":23,"_24":25,"_26":27,"_28":29,"_30":31,"_32":16,"_33":34},"loginname","longdan","page",1,"limit",50,"total","id","639","avatar_url","http://www.gravatar.com/avatar/083aa120de0ff79578fa47e7e07d85f7?s=48","githubUsername","","create_at","2011-09-12 23:44:12","score",5,"topic_count",0,"reply_count","is_star",false,{"_20":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":34,"_47":34,"_32":48,"_49":50,"_26":51,"_52":53},"133","author_id","2","tab","content","

近期对node下的几个mysql操作库做了一下简单的调研
主要是针对这3个module进行
libmysqlclient,mysql-native, mysql

node-libmysqlclient

https://github.com/Sannis/node-mysql-libmysqlclient
基于libmysql的封装, 支持阻塞与非阻塞两种操作方式,目前在query部分功能比较完善,prepare statement方面还是有些bug,实际测试中一直出core

安装

npm install mysql-libmysqlclient

node-mysql

https://github.com/felixge/node-mysql
纯node的实现, 支持prepare statement, 数据的获取支持事件与callback两种方式

安装

npm install mysql

node-mysql-native

https://github.com/sidorares/nodejs-mysql-native

纯node的实现, 内置有简单的连接池支持,支持prepare statement, 数据的获取只支持通过事件方式

安装

npm install mysql-native

测试设计

测试表结构

CREATE TABLE `test10` (
\t`id` int(10) unsigned NOT NULL DEFAULT '0',
\t`txt` varchar(500) DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

测试数据

分别生成了含10, 100, 500, 1500行记录的4张表
使用10个并发连接分别对其进行SELECT * FROM table的查询

测试结论

$\"NewImage.jpg\"$

其中数值表示qps值

在结果集较小时node-mysql-native明显胜出
当结果集增大到接近100行时,node-libmysqlclient开始表现出更佳的性能
node-mysql性能与其他两个module差距比较大,如果对性能有一定要求的话,则其基本不可用

测试代码

http://code.google.com/p/cnodejs/source/browse/#svn%2Ftrunk%2Fmysql-benchmark

","title","nodejs下mysql性能测试","last_reply_at","2016-04-07 06:32:58.684","good","top",15,"visit_count",25390,"2011-02-14 10:45:18","author",{"_13":54,"_22":55},"qingdu","http://www.gravatar.com/avatar/2e26ae3b35ec2d132acc318e7b3a4abb?s=48"]