[jira] [Created] (FINERACT-1114) 100% CPU utilisation

["Roshan Ratnaweera (Jira)" <ji...@apache.org>]

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)