Hi james!
Thanks for escalating the issue!
Its great that I am receiving such fast responses from you all!
I have already added issues in the issuetracker!
Hope to find help asap.
Regards,
Naganand
AGM [Information Technology Department]
Grameen Koota,
Avalahalli, Anjanapura Post
Bangalore- 560062
Email: [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone: 080-28436838,
Mob: 9341940803
Website: www.grameenkoota.org
-----Original Message-----
From: j dailey [mailto:[EMAIL PROTECTED]
Sent: 14 November,2007 09:39 AM
To: [email protected]
Cc: [EMAIL PROTECTED]
Subject: Mifos production issues and likely hibernate connection pooling
Yesterday, Naganand, who is running Mifos in production at Grameen Koota
posted the plea below - basically GF's largest (known) Mifos customer. It
sounded to me like a pretty big deal, requiring some sort of immediate
response at a technical level. Sorry to jump on toes, but was there a
response off listserv?
The likely problem here is that the database connections are being opened
and not closed properly (each query is left open as a separate connection )
- so someone with good hibernate chops might need to be drafted into this
(Sam Lee - I see you are active now and I recall you had this skill?).
Maybe this link would be helpful?
http://www.informit.com/articles/article.aspx?p=353736&seqNum=4
At a minimum, it looks as if the stress testing regime and unit tests around
this are weak.
(Hiya Naganand - hope you are doing well. )
- James
----------------------------------------------------------------------
Message: 1
Date: Mon, 12 Nov 2007 05:42:09 -0500
From: "Amy Bensinger (Contractor)" <[EMAIL PROTECTED]>
Subject: [Mifos-developer] FW: Information on database performance and
optimizations?
To: "Developer" <[email protected]>, "Mifos
functional discussions" <[EMAIL PROTECTED]>
Message-ID:
<[EMAIL PROTECTED]>
Content-Type: text/plain; charset="us-ascii"
Forwarding a post on behalf of Nagananda...
From: Naganand [mailto:[EMAIL PROTECTED]
Sent: 12 November,2007 04:00 PM
To: '[EMAIL PROTECTED]'
Subject:
Hi all,
Greetings from Grameen Koota!
We have an issue on our live server. Can anybody help us!
We have 44 branches running live on the server and most of them do data
entry using low speed internet connections. The connection is sometime
strong and sometime week and breaking.
It so happens that sometimes mysql on our database server overshoots
the
number of users which is currently defined as 150 [though the number of
branches are only 44 + another 10 users max] and the server hangs and
stops responding. If I increase the users limit then the server starts
responding slowly.
Also sometimes the branches load reports and there is a connection
breakage inbetween. Then the users reconnect and reload the reports.
But
in the server the old queries does not end and mysql hangs. We need to
restart mysql or kill the queries 1 by 1 and then the server works
faster.
Can anybody help us know why does the no. of users go out of limit?
And why do the queries hang instead of ending when the user is
disconnected from the net?
Regards,
Naganand
AGM [Information Technology Department]
Grameen Koota,
Avalahalli, Anjanapura Post
Bangalore- 560062
Email: [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone: 080-28436838,
Mob: 9341940803
Website: www.grameenkoota.org
____________________________________________________________________________
________
Be a better sports nut! Let your teams follow you
with Yahoo Mobile. Try it now.
http://mobile.yahoo.com/sports;_ylt=At9_qDKvtAbMuh1G1SQtBI7ntAcJ
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
