《Druid数据库连接池介绍资料教程》由会员分享，可在线阅读，更多相关《Druid数据库连接池介绍资料教程（16页珍藏版）》请在金锄头文库上搜索。
1、温绍锦(温高铁) ,Druid数据库连接池的特点,稳定 高效率 可扩展 可监控 可动态配置 防SQL注入,稳定,阿里巴巴大规模部署 应用超过500个 部署实例超过3000 最大集群超过60台 我们大规模使用中，开源连接池只有两个是稳定的： Druid DataSource Jboss DataSource （历史原因还在使用）,Oracle Fatal Excetion,MySql Fatal Exception,高性能,详细测试信息： ,Druid是目前性能最好的数据库连接池,SQL Parser,Parser基本概念 词法分析 Token 语法分析 抽象语法树 表达式 语句,手写Parse
2、r的性能,Cobar的SQL Parser，从Antlr生成的parser修改为Druid Parser之后，大约提升6倍的性能。 Druid Parser最近再次大幅度提升性能(50%) SQL Parser的关键在于词法 词法分析要支持预测,监控,Spring关联监控,Web关联监控,查看SQL执行明细,配置filters=log4j,2013-07-12 16:10:17,966 DEBUG Connection:132 - conn-10001 connected 2013-07-12 16:10:17,970 DEBUG Connection:132 - conn-10001 com
3、mited 2013-07-12 16:10:17,970 DEBUG Connection:132 - conn 10001 rollback 2013-07-12 16:10:17,983 DEBUG Statement:137 - conn-10001, stmt-20000 created 2013-07-12 16:10:17,986 DEBUG Statement:137 - conn-10001, stmt-20000 executed. 0.052501 millis. SELECT 1 2013-07-12 16:10:17,986 DEBUG Statement:137 -
4、 conn-10001, stmt-20000 batch executed. 0.041842 millis. SELECT 1 2013-07-12 16:10:18,205 DEBUG Statement:137 - conn-10001, stmt-20000, rs-50000 query executed. 219.082247 millis. SELECT 1 2013-07-12 16:10:18,205 DEBUG ResultSet:142 - conn-10001, stmt-20000, rs-50000 open 2013-07-12 16:10:18,206 DEB
5、UG ResultSet:142 - conn-10001, stmt-20000, rs-50000 Header: null 2013-07-12 16:10:18,206 DEBUG Statement:137 - conn-10001, stmt-20000 update executed. effort 0. 0.019343 millis. SELECT 1 2013-07-12 16:10:18,223 DEBUG Statement:137 - conn-10001, pstmt-20001 created. SELECT 1 2013-07-12 16:10:18,260 D
6、EBUG Statement:137 - conn-10001, pstmt-20001 Parameters : null, null, null, null, com.alibaba.druid.mock.MockBlob34aee875, 1, B471f7458, null, com.alibaba.druid.mock.MockClob620f61e2, null, 1.0, 1, 1, null, com.alibaba.druid.mock.MockNClob5fe36eb9, null, null, null, com.alibaba.druid.mock.MockRef4c7
7、a64dd, com.alibaba.druid.mock.MockRowId77741064, 1, com.alibaba.druid.mock.MockSQLXML64e05280, , null, null, null, null 2013-07-12 16:10:18,260 DEBUG Statement:137 - conn-10001, pstmt-20001 Types : ARRAY, OTHER, DECIMAL, OTHER, BLOB, TINYINT, OTHER, OTHER, CLOB, DATE, FLOAT, INTEGER, BIGINT, OTHER,
8、NCLOB, NVARCHAR, VARCHAR, OTHER, REF, ROWID, SMALLINT, SQLXML, VARCHAR, TIME, TIMESTAMP, OTHER, OTHER 2013-07-12 16:10:18,260 DEBUG Statement:137 - conn-10001, pstmt-20001 executed. 0.564872 millis. SELECT 1 2013-07-12 16:10:18,260 DEBUG Statement:137 - conn-10001, pstmt-20001 batch executed. 0.0075
9、 millis. SELECT 1 2013-07-12 16:10:18,260 DEBUG Statement:137 - conn-10001, pstmt-20001 Parameters : null, null, null, null, com.alibaba.druid.mock.MockBlob34aee875, 1, B471f7458, null, com.alibaba.druid.mock.MockClob620f61e2, null, 1.0, 1, 1, null, com.alibaba.druid.mock.MockNClob5fe36eb9, null, nu
10、ll, null, com.alibaba.druid.mock.MockRef4c7a64dd, com.alibaba.druid.mock.MockRowId77741064, 1, com.alibaba.druid.mock.MockSQLXML64e05280, , null, null, null, null 2013-07-12 16:10:18,262 DEBUG Statement:137 - conn-10001, pstmt-20001 Types : ARRAY, OTHER, DECIMAL, OTHER, BLOB, TINYINT, OTHER, OTHER,
11、CLOB, DATE, FLOAT, INTEGER, BIGINT, OTHER, NCLOB, NVARCHAR, VARCHAR, OTHER, REF, ROWID, SMALLINT, SQLXML, VARCHAR, TIME, TIMESTAMP, OTHER, OTHER 2013-07-12 16:10:18,262 DEBUG Statement:137 - conn-10001, pstmt-20001, rs-50001 query executed. 1.805932 millis. SELECT 1 2013-07-12 16:10:18,262 DEBUG Res
12、ultSet:142 - conn-10001, pstmt-20001, rs-50001 open 2013-07-12 16:10:18,263 DEBUG ResultSet:142 - conn-10001, pstmt-20001, rs-50001 Header: null 2013-07-12 16:10:18,263 DEBUG Statement:137 - conn-10001, pstmt-20001 Parameters : null, null, null, null, com.alibaba.druid.mock.MockBlob34aee875, 1, B471
13、f7458, null, com.alibaba.druid.mock.MockClob620f61e2, null, 1.0, 1, 1, null, com.alibaba.druid.mock.MockNClob5fe36eb9, null, null, null, com.alibaba.druid.mock.MockRef4c7a64dd, com.alibaba.druid.mock.MockRowId77741064, 1, com.alibaba.druid.mock.MockSQLXML64e05280, , null, null, null, null 2013-07-12
14、 16:10:18,263 DEBUG Statement:137 - conn-10001, pstmt-20001 Types : ARRAY, OTHER, DECIMAL, OTHER, BLOB, TINYINT, OTHER, OTHER, CLOB, DATE, FLOAT, INTEGER, BIGINT, OTHER, NCLOB, NVARCHAR, VARCHAR, OTHER, REF, ROWID, SMALLINT, SQLXML, VARCHAR, TIME, TIMESTAMP, OTHER, OTHER 2013-07-12 16:10:18,263 DEBU
15、G Statement:137 - conn-10001, pstmt-20001 update executed. effort 0. 0.287765 millis. SELECT 1 2013-07-12 16:10:18,274 DEBUG Statement:137 - conn-10001, cstmt-20002 created. SELECT 1 2013-07-12 16:10:18,274 DEBUG Statement:137 - conn-10001, stmt-20000, rs-50002 query executed. 0.081711 millis. SELEC
16、T 1 2013-07-12 16:10:18,274 DEBUG ResultSet:142 - conn-10001, stmt-20000, rs-50002 open 2013-07-12 16:10:18,274 DEBUG ResultSet:142 - conn-10001, stmt-20000, rs-50002 Header: null 2013-07-12 16:10:18,275 DEBUG ResultSet:142 - conn-10001, stmt-20000, rs-50002 Result: 1,防御SQL注入,配置filters=“wall” 智能拦截永真条件 智能拦截系统函数调用 智能拦截系统表访问,集中配置、动态配置,filters=“config” 支持数据库密码加密 支持从本地或者http远程读取配置文件,
