beecp-starter
beecp-starter copied to clipboard
Chris2018998
最新版 监控数据无法显示
制作了一个临时包：
https://github.com/Chris2018998/BeeCP-Starter/blob/master/doc/temp/beecp-spring-boot-starter-1.6.8.jar
周末再发正式包
Spring配置
spring:
数据源配置
datasource: monitorUserId: beecpasas monitorPassword: 1144388620 sql-trace: true sql-show: true sql-trace-max-size: 100 sql-trace-timeout: 600000 sql-exec-alert-time: 3000 sql-trace-timeout-scan-period: 18000 sql-exec-alert-action: com.xysy.framework.config.SqlAlertConfig type: cn.beecp.BeeDataSource poolName: BeeCP1 username: ENC(SasaZ6VJNjDjvP+nht18kU9aQ==) password: ENC(ttRJasas6XDgR4vt6EAYXw7d5jFoBVXtis3wJPO4yP03MY=) jdbcUrl: jdbc:mysql://101.xxxxxx.48:xxx/monitor?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8&allowMultiQueries=true&rewriteBatchedStatements=true&connectTimeout=60000&socketTimeout=60000&autoReconnect=true driverClassName: com.mysql.cj.jdbc.Driver maxActive: 400 initialSize: 10 connectionTestInterval: 5000 validTestSql: select 1
spring: datasource: monitorUserId: beecpasas monitorPassword: 1144388620 sql-trace: true sql-show: true sql-trace-max-size: 100 sql-trace-timeout: 600000 sql-exec-alert-time: 3000 sql-trace-timeout-scan-period: 18000 sql-exec-alert-action: com.xysy.framework.config.SqlAlertConfig type: cn.beecp.BeeDataSource poolName: BeeCP1 username: ENC(SasaZ6VJNjDjvP+nht18kU9aQ==) password: ENC(ttRJasas6XDgR4vt6EAYXw7d5jFoBVXtis3wJPO4yP03MY=) jdbcUrl: jdbc:mysql://101.xxxxxx.48:xxx/monitor?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8&allowMultiQueries=true&rewriteBatchedStatements=true&connectTimeout=60000&socketTimeout=60000&autoReconnect=true driverClassName: com.mysql.cj.jdbc.Driver maxActive: 400 initialSize: 10 connectionTestInterval: 5000 validTestSql: select 1
spring: datasource: monitorUserId: beecpasas monitorPassword: 1144388620 sql-trace: true sql-show: true sql-trace-max-size: 100 sql-trace-timeout: 600000 sql-exec-alert-time: 3000 sql-trace-timeout-scan-period: 18000 sql-exec-alert-action: com.xysy.framework.config.SqlAlertConfig type: cn.beecp.BeeDataSource poolName: BeeCP1 username: ENC(SasaZ6VJNjDjvP+nht18kU9aQ==) password: ENC(ttRJasas6XDgR4vt6EAYXw7d5jFoBVXtis3wJPO4yP03MY=) jdbcUrl: jdbc:mysql://101.xxxxxx.48:xxx/monitor?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8&allowMultiQueries=true&rewriteBatchedStatements=true&connectTimeout=60000&socketTimeout=60000&autoReconnect=true driverClassName: com.mysql.cj.jdbc.Driver maxActive: 400 initialSize: 10 connectionTestInterval: 5000 validTestSql: select 1
1： sql-exec-alert-action配置的类需要继承 StatementTraceAlert，例如
public class TestAlert extends StatementTraceAlert {
public void alert(List<StatementTrace> alertList) {
System.out.println("....test alert siz:" + alertList.size());
}
}
2: 链接监控监控是正常的，SQL监控是有点问题，没有显示出数据
SQL未显示出的问题，尽快解决
试试这个包： https://github.com/Chris2018998/BeeCP-Starter/blob/master/doc/temp/beecp-spring-boot-starter-1.6.9-Pre.jar
你看能否把这个内存溢出问题的详情描述一下？在什么情况发生的？机器可用内存多少？失败了多少次才出现泄露？BeeCP很少缓存一些数据，依据经验来看，应该不至于导致内存问题。
建议1：在你的机器直接使用驱动，做一个连接失败的同等模拟测试，看看是否出现问题。
建议2：使用内存监控工具看看哪些类的实例比较多。
当有大量连接失败的时候 出现大量Communications link failure 出现lsq连接内存泄漏
已经修复了这个问题，有时间可以试试下面链接中包，过段时间再发正式包。
https://github.com/Chris2018998/BeeCP-Starter/blob/master/doc/temp/beecp-spring-boot-starter-1.7.0.jar