You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@fineract.apache.org by "Roshan Ratnaweera (Jira)" <ji...@apache.org> on 2021/05/03 10:11:01 UTC
[jira] [Updated] (FINERACT-1114) Slow Query
[ https://issues.apache.org/jira/browse/FINERACT-1114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Roshan Ratnaweera updated FINERACT-1114:
----------------------------------------
Description:
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 ?
was:
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 ?
Environment:
Server configuration is 16 vCPU, 64GB RAM and 250GB SSD storage.
Mifos setup has been done using AWS-AMI
was:
Server configuration is 16 vCPU, 64GB RAM and 250GB SSD storage.
Mifos 17.07.01 setup has been done using AWS-AMI
> 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 setup has been done using AWS-AMI
> Reporter: Roshan Ratnaweera
> Priority: Critical
> Labels: scalability
> Attachments: Slow Query Loan Disbursement.sql, Slow Query Teller Cash Management Transactions.sql
>
>
> 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)