注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

阿弥陀佛

街树飘影未见尘 潭月潜水了无声 般若观照心空静...

 
 
 

日志

 
 
关于我

一直从事气象预报、服务建模实践应用。 注重气象物理场、实况场、地理信息、本体知识库、分布式气象内容管理系统建立。 对Barnes客观分析, 小波,计算神经网络、信任传播、贝叶斯推理、专家系统、网络本体语言有一定体会。 一直使用Java、Delphi、Prolog、SQL编程。

网易考拉推荐

Seting ramadda.db.pool.maxactive  

2012-11-16 09:04:38|  分类: Ramadda |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |

- 隐藏引用文字 -
    We have run the 260 Ramaddas for a few days, we use the command 'show processlists' to see the current connection number of MySQL, finding that there are already 1402 connections(as shown in the attached picture) and this number keep in increasing every day. We have encountered several times that the connection pool was full and Ramadda crashed. We feel that there might be some database connections not been released after uploading or browser visited. Could you please check the source code to see if this problem exists and solve it. Thank you again.



Go to the Admin->System->Database Statistics->Connection Pool page. This will show the status of the connection pool for that repository. What does this show?

JDBC URL:    jdbc:mysql://localhost:3306/china?zeroDateTimeBehavior=convertToNull&initialTimeout=1000&connectTimeout=5000
数据库统计
连接池
  #active:0
  #idle:6
  max active: 10
  max idle:10
# of open selects:0

.....


You have 5 or 6 idle connections per ramadda  - that is why there are 1400+ connections.  Each of the repositories is holding a pool of connections. You can configure the pool size with the properties:

ramadda.db.pool.maxactive=100
ramadda.db.pool.maxidle=100

maybe try setting maxidle=1 or 2

-Jeff


revision :1987
ramadda.db.pool.maxactive=100
ramadda.db.pool.maxidle=5
ramadda.db.pool.timeuntilclosed=300


The system crashed this morning. I can`t confirm what result in this time. Could you help me find the errror?
Thank you
Xianfeng He


That is an internal JVM error so not an error in the Java code. How long had your tomcat been running?

-Jeff
  评论这张
 
阅读(680)| 评论(0)
推荐 转载

历史上的今天

在LOFTER的更多文章

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017