Druid SQL监控的几种方式

1.监控页面

2.JMX

	 
	<servlet>
		<servlet-name>DruidStatView</servlet-name>
		<servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>
		
	    <!-- 远程访问JavaSE项目使用jmx连接 -->
	    <init-param>
            <param-name>jmxUrl</param-name>
            <param-value>service:jmx:rmi:///jndi/rmi://192.168.1.76:9004/jmxrmi</param-value>
        </init-param>
	</servlet>
	<servlet-mapping>
		<servlet-name>DruidStatView</servlet-name>
		<url-pattern>/druid/*</url-pattern>
	</servlet-mapping>

3.shell脚本

druidStat.sh

本质与第二种一致，都是通过JMX连接本地JVM进程，调用MBean 操作方法com.alibaba.druid:type=DruidStatService(该MBean仅包含操作，可通过JConsole自带工具查看到)。

• 原理

com.alibaba.druid.support.console.DruidStat#printDruidStat

cat > druidStat.sh << EOF
#!/bin/sh

if [ -z "$JAVA_HOME" ] ; then
  echo "Error: JAVA_HOME is not defined."
  exit 1
fi

"$JAVA_HOME/bin/java" -Dfile.encoding="UTF-8" -cp "./druid-1.2.8.jar:$JAVA_HOME/lib/tools.jar" com.alibaba.druid.support.console.DruidStat  $@
EOF

chmod u+x druidStat.sh

对于K8S容器环境下，操作过程如下

• 容器交互

kubectl -n my-namespace exec -it app-9f577f598-rj427 -- /bin/sh

• 查看jre安装目录

ls -al /usr/bin/java
ls -al /etc/alternatives/java

• 监控SQL

注意:下文中的PID替换进程号即jps -l查询结果

cd /app
jar -xvf app.jar
cp BOOT-INF/lib/druid-1.2.8.jar  /app/
jps -l
java -Dfile.encoding="UTF-8" -cp "./druid-1.2.8.jar:/usr/lib/jvm/java-8-openjdk-amd64/lib/tools.jar" com.alibaba.druid.support.console.DruidStat -help pid

java -Dfile.encoding="UTF-8" -cp "./druid-1.2.8.jar:/usr/lib/jvm/java-8-openjdk-amd64/lib/tools.jar" com.alibaba.druid.support.console.DruidStat -ds pid 5

java -Dfile.encoding="UTF-8" -cp "./druid-1.2.8.jar:/usr/lib/jvm/java-8-openjdk-amd64/lib/tools.jar" com.alibaba.druid.support.console.DruidStat -sql pid 5

java -Dfile.encoding="UTF-8" -cp "./druid-1.2.8.jar:/usr/lib/jvm/java-8-openjdk-amd64/lib/tools.jar" com.alibaba.druid.support.console.DruidStat -sql -id 32  -detail pid

4.直接调用本地MbeanServer Mbean操作

    /**
     * @see com.alibaba.druid.stat.DruidStatService#service(java.lang.String)
     */
	String url = Option.getUrl(Option.SQL);
	ObjectName name = new ObjectName(DruidStatService.MBEAN_NAME);
	MBeanServer mBeanServer = ManagementFactory.getPlatformMBeanServer();
	Object result = mBeanServer.invoke(name, "service", new String[]{url}, new String[]{String.class.getName()});
	log.info("SQL Stat=>{}", result);

转载：
Druid Monitor监控JavaSE和JavaWeb