Druid数据库连接池介绍 PPT课件.pptx

《Druid数据库连接池介绍 PPT课件.pptx》由会员分享，可在线阅读，更多相关《Druid数据库连接池介绍 PPT课件.pptx（16页珍藏版）》请在三一办公上搜索。

1、温绍锦(温高铁)weibo/wengaotie,Druid数据库连接池的特点,稳定高效率可扩展可监控可动态配置防SQL注入,稳定,阿里巴巴大规模部署应用超过500个部署实例超过3000最大集群超过60台我们大规模使用中，开源连接池只有两个是稳定的：Druid DataSourceJboss DataSource （历史原因还在使用）,稳定的特性-ExceptionSorter,当连接产生不可恢复的异常时，需要及时从连接池中清除，否则会产生大量错误。这个功能也称为ExceptionSorter，只有JBossDataSource和DruidDataSource实现了这个功能。,Oracle Fa

2、tal Excetion,MySql Fatal Exception,高性能,详细测试信息：https:/github/alibaba/druid/wiki/%E5%90%84%E7%A7%8D%E8%BF%9E%E6%8E%A5%E6%B1%A0%E6%80%A7%E8%83%BD%E5%AF%B9%E6%AF%94%E6%B5%8B%E8%AF%95,Druid是目前性能最好的数据库连接池,SQL Parser,Parser基本概念词法分析Token语法分析抽象语法树表达式语句,手写Parser的性能,Cobar的SQL Parser，从Antlr生成的parser修改为Druid Par

3、ser之后，大约提升6倍的性能。Druid Parser最近再次大幅度提升性能(50%)SQL Parser的关键在于词法词法分析要支持预测,监控,Spring关联监控,Web关联监控,查看SQL执行明细,配置filters=log4j,2019-07-12 16:10:17,966 DEBUG Connection:132 - conn-10001 connected2019-07-12 16:10:17,970 DEBUG Connection:132 - conn-10001 commited2019-07-12 16:10:17,970 DEBUG Connection:132 - c

4、onn 10001 rollback2019-07-12 16:10:17,983 DEBUG Statement:137 - conn-10001, stmt-20000 created2019-07-12 16:10:17,986 DEBUG Statement:137 - conn-10001, stmt-20000 executed. 0.052501 millis. SELECT 12019-07-12 16:10:17,986 DEBUG Statement:137 - conn-10001, stmt-20000 batch executed. 0.041842 millis.

5、SELECT 12019-07-12 16:10:18,205 DEBUG Statement:137 - conn-10001, stmt-20000, rs-50000 query executed. 219.082247 millis. SELECT 12019-07-12 16:10:18,205 DEBUG ResultSet:142 - conn-10001, stmt-20000, rs-50000 open2019-07-12 16:10:18,206 DEBUG ResultSet:142 - conn-10001, stmt-20000, rs-50000 Header:

6、null2019-07-12 16:10:18,206 DEBUG Statement:137 - conn-10001, stmt-20000 update executed. effort 0. 0.019343 millis. SELECT 12019-07-12 16:10:18,223 DEBUG Statement:137 - conn-10001, pstmt-20001 created. SELECT 12019-07-12 16:10:18,260 DEBUG Statement:137 - conn-10001, pstmt-20001 Parameters : null,

7、 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.MockRef4c7a64dd, com.alibaba.druid.mock.MockRowId77741064, 1, com.alibaba

8、.druid.mock.MockSQLXML64e05280, , null, null, null, null2019-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, NCLOB, NVARCHAR, VARCHAR, OTHER, REF, ROWID, SMALLINT, SQLXML, V

9、ARCHAR, TIME, TIMESTAMP, OTHER, OTHER2019-07-12 16:10:18,260 DEBUG Statement:137 - conn-10001, pstmt-20001 executed. 0.564872 millis. SELECT 12019-07-12 16:10:18,260 DEBUG Statement:137 - conn-10001, pstmt-20001 batch executed. 0.0075 millis. SELECT 12019-07-12 16:10:18,260 DEBUG Statement:137 - con

10、n-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.MockRef4c7a64dd, com.alibaba.druid

11、.mock.MockRowId77741064, 1, com.alibaba.druid.mock.MockSQLXML64e05280, , null, null, null, null2019-07-12 16:10:18,262 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,

12、 OTHER, REF, ROWID, SMALLINT, SQLXML, VARCHAR, TIME, TIMESTAMP, OTHER, OTHER2019-07-12 16:10:18,262 DEBUG Statement:137 - conn-10001, pstmt-20001, rs-50001 query executed. 1.805932 millis. SELECT 12019-07-12 16:10:18,262 DEBUG ResultSet:142 - conn-10001, pstmt-20001, rs-50001 open2019-07-12 16:10:18

13、,263 DEBUG ResultSet:142 - conn-10001, pstmt-20001, rs-50001 Header: null2019-07-12 16:10:18,263 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, n

14、ull, 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, null2019-07-12 16:10:18,263 DEBUG Statement:137 - conn-10001, pstmt-20001 Types : ARRAY

15、, 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, OTHER2019-07-12 16:10:18,263 DEBUG Statement:137 - conn-10001, pstmt-20001 update executed. effort 0. 0.287

16、765 millis. SELECT 12019-07-12 16:10:18,274 DEBUG Statement:137 - conn-10001, cstmt-20002 created. SELECT 12019-07-12 16:10:18,274 DEBUG Statement:137 - conn-10001, stmt-20000, rs-50002 query executed. 0.081711 millis. SELECT 12019-07-12 16:10:18,274 DEBUG ResultSet:142 - conn-10001, stmt-20000, rs-50002 open2019-07-12 16:10:18,274 DEBUG ResultSet:142 - conn-10001, stmt-20000, rs-50002 Header: null2019-07-12 16:10:18,275 DEBUG ResultSet:142 - conn-10001, stmt-20000, rs-50002 Result: 1,防御SQL注入,配置filters=“wall”智能拦截永真条件智能拦截系统函数调用智能拦截系统表访问,集中配置、动态配置,filters=“config”支持数据库密码加密支持从本地或者http远程读取配置文件,