1、添加druid的jar包到【${Tomcat_home}/lib】目录


2、在【${Tomcat_home}/conf/server.xml】中增加jndi数据源

<Resource name="jdbc/MyDataSource" auth="Container" type="javax.sql.DataSource" factory="com.alibaba.druid.pool.DruidDataSourceFactory"
username="root"
password="123456"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/camdb_training?useUnicode=true&characterEncoding=utf8&useSSL=false"
filters="stat,wall"
connectionProperties="druid.stat.mergeSql=true;druid.stat.slowSqlMillis=2000"
useGlobalDataSourceStat="true"
defaultTransactionIsolation="READ_COMMITTED"
validationQuery="select 1" />

该节点位于Server节点之下,和Listener节点平级


3、配置监控界面

在该文件【${Tomcat_home}/conf/web.xml】中添加以下内容

在servlet同级节点添加

<servlet>
	<servlet-name>DruidStatView</servlet-name>
	<servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>
	<init-param>
		<!-- 允许清空统计数据 -->
		<param-name>resetEnable</param-name>
		<param-value>true</param-value>
		</init-param>
		<init-param>
		<!-- 用户名 -->
		<param-name>loginUsername</param-name>
		<param-value>admin</param-value>
		</init-param>
		<init-param>
		<!-- 密码 -->
		<param-name>loginPassword</param-name>
		<param-value>admin</param-value>
	</init-param>
</servlet>

<servlet-mapping>
<servlet-name>DruidStatView</servlet-name>
<url-pattern>/druid/*</url-pattern>
</servlet-mapping>


4、通过访问http://localhost:8080/druid 界面,用户名admin,密码admin就可访问监控界面了。



GitHub 加速计划 / druid / druid
6
4
下载
阿里云计算平台DataWorks(https://help.aliyun.com/document_detail/137663.html) 团队出品,为监控而生的数据库连接池
最近提交(Master分支:3 个月前 )
3246166f - Add constructor with SQLParserFeature support to SparkStatementParser - Fix SQLParserUtils to pass features parameter to SparkStatementParser, CKStatementParser and StarRocksStatementParser 4 天前
78fa7415 - Add CKDropTableStatement to handle DROP TABLE with ON CLUSTER syntax - Add parseDropTableAfterName extension point in SQLStatementParser - Implement parseDropTableAfterName in CKStatementParser for ON CLUSTER parsing - Support DEFAULT keyword as cluster name in both CREATE/DROP TABLE - Add visitor methods in CKASTVisitor and CKOutputVisitor for CKDropTableStatement - Add test cases in 6.txt for DROP TABLE and CREATE TABLE with ON CLUSTER - All 43 ClickHouse tests passing 22 天前
Logo

AtomGit 是由开放原子开源基金会联合 CSDN 等生态伙伴共同推出的新一代开源与人工智能协作平台。平台坚持“开放、中立、公益”的理念,把代码托管、模型共享、数据集托管、智能体开发体验和算力服务整合在一起,为开发者提供从开发、训练到部署的一站式体验。

更多推荐