[{"_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":20},"replies",[35,36],"user",{"_21":22,"_13":14,"_23":24,"_25":26,"_27":28,"_29":30,"_31":16,"_32":16,"_33":34},"loginname","longbill","page",1,"limit",50,"total",2,"id","27","avatar_url","http://www.gravatar.com/avatar/4c564c9b7fad37a790b560904df49c13?s=48","githubUsername","","create_at","2011-03-26 08:31:26","score",10,"topic_count","reply_count","is_star",false,{"_21":57,"_38":58,"_40":-5,"_41":59,"_43":60,"_45":61,"_47":34,"_48":34,"_32":62,"_50":63,"_27":64,"_53":65},{"_21":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":34,"_48":34,"_32":49,"_50":51,"_27":52,"_53":54},"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":55,"_23":56},"qingdu","http://www.gravatar.com/avatar/2e26ae3b35ec2d132acc318e7b3a4abb?s=48","72","3","NAE - Node App Engine (powered by CNodeJS) 开始小范围内测。\r\n
\r\n
项目地址：http://cnodejs.net\r\n
\r\n
$\"\"$ \r\n
\r\n
当前版本支持Node应用托管、在线开发、多人协作、代码上传、二级域名绑定、mongodb空间和在线数据管理，每个用户可以支持10个应用。未来将支持git代码管理、在线调试等。\r\n
\r\n
即日开始陆续对CNode社区的志愿者发放邀请码，CNode社区贡献过技术文章的作者都将首批获得邀请码。\r\n

如果你想获得NAE的邀请码？

\r\n
请给CNode社区投稿即可获得邀请码，不限Node初学者入门、自己翻译的技术文章、学习笔记等原创技术文章。欢迎大家为社区做贡献，帮助更多的同学了解和熟悉Node。\r\n

如果你已经获得邀请码？

\r\n
请阅读用户手册： http://blog.cnodejs.net/post/4e686c290716ac9910000009\r\n
\r\n
获得邀请码的朋友们及时给我们反馈，以便帮助我们尽快的完善NAE。\r\n
\r\n
技术反馈： http://blog.cnodejs.net/post/4e686bb00716ac9910000003\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
谢谢大家一直来对CNode社区的支持。\r\n
\r\n
NAE的开发博客地址： http://blog.cnodejs.net","Node App Engine开始内测","2014-08-26 03:40:45.385",191,37626,"2011-09-08 08:20:03",{"_13":66,"_23":67},"kongwu","http://www.gravatar.com/avatar/1bfc8def4d9f790b4157a17aeba5f55e?s=48"]