Hi Rohit,
Thanks for asking, my reply below
- which APIs you think have degraded ->
listing instances
- how have you concluded that they are degrading? ->
we have an upper app that has a configured timeout and it wasn’t
firing, we had to change the value, and it is visible as well, it takes 5.6s
bringing 5 vms.
- are those list API or other async/action oriented APIs? ->
yes, it it async
- which version of CloudStack and MySQL server is this, other details about
your env (hypervisor, scale/size of resources etc).
ACS 4.18.0. —> 4GB 2Cores
Mariadb 10.5.x -> 4GB 2Cores
Hyp KVM
- does restarting mgmt server help? any other information on how to reproduce
this?
no change
We are guessing it is related to database performance/index as it not happening
in QA
Atte,
Ricardo Pertuz
On 24 Aug 2023, 6:33 AM -0500, Rohit Yadav <[email protected]>, wrote:
> Hi Ricardo,
>
> Can you share more details, such as;
>
> - which APIs you think have degraded
> - how have you concluded that they are degrading?
> - are those list API or other async/action oriented APIs?
> - which version of CloudStack and MySQL server is this, other details about
> your env (hypervisor, scale/size of resources etc)
> - does restarting mgmt server help? any other information on how to reproduce
> this?
>
>
> Regards.
>
> ________________________________
> From: Kuasar <[email protected]>
> Sent: Wednesday, August 23, 2023 22:00
> To: [email protected] <[email protected]>
> Subject: Query to Cloudstack API is degraded
>
> During the last weeks we have been experiencing a degrading performance in
> API queries to Cloudstack, is there a procedure you recommend to check the
> possible bottleneck?, we are checking database indices.
>
>
> BR,
>
> Ricardo Pertuz
>
>
>
>
>
