Roshan Ratnaweera created FINERACT-1114:
-------------------------------------------
Summary: 100% CPU utilisation
Key: FINERACT-1114
URL: https://issues.apache.org/jira/browse/FINERACT-1114
Project: Apache Fineract
Issue Type: Improvement
Components: Performance
Environment: Server configuration is 16 vCPU, 64GB RAM and 250GB SSD
storage.
Mifos 17.07.01 setup has been done using AWS-AMI
Reporter: Roshan Ratnaweera
Attachments: Slow Query Loan Disbursement.sql, Slow Query Teller Cash
Management Transactions.sql
I am using the 17.07.01 version. Server configuration is *16 vCPU, 64GB RAM*
and SSD storage. There are maximum concurrent user count is 30 (from 15
branches)
# Loan disbursement
# viewing the net amount of teller (Teller cash management)
Above two tasks are taking a long time to process. When a bunch of these two
tasks are running, server CPU are 100% utilized by relevant sql select queries.
When the server is not going to normal status, I am killing frozen select
queries. Then suddenly the server is going back to normal.
I have noticed that these delayed two queries, read all transactions of
relevant users. I think, that is why it takes a long time to process. Are any
solutions available for this ?
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
