[
https://issues.apache.org/jira/browse/FINERACT-1114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roshan Ratnaweera updated FINERACT-1114:
----------------------------------------
Summary: Slow Query (was: 100% CPU utilisation )
> Slow Query
> ----------
>
> Key: FINERACT-1114
> URL: https://issues.apache.org/jira/browse/FINERACT-1114
> Project: Apache Fineract
> Issue Type: Bug
> 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
> Priority: Critical
> Labels: performance
> 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)
