使用jdbc池的grails 2.2.4中的MySQL语句取消定时器处于等待状态 [英] MySQL Statement Cancellation Timer in waiting state in grails 2.2.4 with jdbc pool

问题描述

我在2.2.4版的grails应用程序上使用了jdbcpool 7.0.47。当我检查threaddump时，它显示大量MySQL语句取消计时器处于等待状态。我也试着将jdbc连接器移动到tomcat / lib，但它开始给mysql一些日期问题。因此，任何其他方式来杀死这些线程

I've used jdbcpool 7.0.47 on grails app with version 2.2.4. When i checked the threaddump it shows that lots of "MySQL Statement Cancellation Timer" are in waiting state. I've also tried moving the jdbc connector to tomcat/lib but it start to give some date issues with mysql. So any other way to kill those threads

推荐答案

好的评估连接池的所有参数似乎 validationQueryTimeOut 导致了所有这些问题。删除该参数后，一切都正常。现在我的工作连接池属性就像这样

Ok evaluating all the params of connection pooling it seems validationQueryTimeOut was causing all this issue. After removing that param everything is normal. Now my working connection pooling properties are like this

properties {
    initialSize=5
    maxActive=50
    minIdle=5
    maxIdle=25
    maxWait = 10000
    maxAge = 10 * 60000
    timeBetweenEvictionRunsMillis=5000
    minEvictableIdleTimeMillis=60000
    validationQuery="SELECT 1"
    validationInterval=15000
    testWhileIdle=true
    testOnBorrow=true
    testOnReturn=false
    jdbcInterceptors = "ConnectionState"
    defaultTransactionIsolation = java.sql.Connection.TRANSACTION_READ_COMMITTED
}

这篇关于使用jdbc池的grails 2.2.4中的MySQL语句取消定时器处于等待状态的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！