Nixon, also, i would suggest keeping an eye on the amount of rows in the vm_stats table. In my case, ACS hasn't been removing them properly and as a result i've accumulated over 25m rows in that table, which caused the slow response in the acs gui.
Something like this: SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = 'cloud'; check the vm_stats rows. If you need to remove some old data, you could do something like this: DELETE FROM vm_stats WHERE timestamp < '2024-05-20 00:00:01'; that will remove all rows with the timestamp older than 20th of May 2024. If you have a lot of data, you might need remove the data in shorter increments. I've found that my /tmp folder didn't have enough space, so i had to play around with dates to remove all the old data. Now, the ACS ui is pretty fast and usable again. Hope that helps. Andriej ----- Original Message ----- > From: "Nixon Varghese K S" <nix...@netstratum.com> > To: "users" <users@cloudstack.apache.org> > Sent: Thursday, 20 June, 2024 12:14:16 > Subject: Re: UI Slowness while populating Instance > Hi, > > Thank you for the suggestions.. > > @Andrei I had done the same settings on global configuration and now UI > seems to be pretty fast.. Thank you so much for the help... > > @Joao Thanks for the information that 14.19.1 will have much improved > functions... > > Thank you guys... > > With Regards > Nixon Varghese > > On Tue, Jun 18, 2024 at 11:47 PM João Jandre Paraquetti < > j...@scclouds.com.br> wrote: > >> Hi, Nixon >> >> What you are experiencing is most likely the same as Andrei (see >> https://lists.apache.org/thread/ltsw9tkkxv6pl2tr9r4q5m34xwlxxbqg), by >> default, the API used by the UI to list the VMs also lists the VM's >> metrics; since you have 100+ VMs, it is understandable that it would >> take some time to list all of those metrics. This behavior has been >> discussed and changed with PR >> https://github.com/apache/cloudstack/pull/8782. On the next minor >> release (4.19.1) there will be a configuration to let you change the >> behavior of the `listVirtualMachines` API so that it does not return the >> metrics by default. >> >> Also, if you have too many metrics collected, you might run into the >> issue that is described here >> https://github.com/apache/cloudstack/pull/8740, where due to the amount >> of metrics that ACS tries to delete in a single query, the query always >> times out, snowballing into a huge amount of metrics on your DB, slowing >> you down even more. The linked PR solves this adding another >> configuration to limit the amount of metrics deleted per query, >> hopefully it will be in by 4.19.1.0. Until then, if you notice that the >> metrics are not being deleted, you might have to manually delete the old >> ones on the DB. >> >> Best regards, >> >> João Jandre >> >> On 6/18/24 06:31, Nixon Varghese K S wrote: >> > Hello, >> > >> > I am using ACS 4.18.0.0v in my production environment, and more than 100 >> > instances, including Kubernetes instances, are running on my setup. The >> > user interface appears to be stuck in the loading phase when you click on >> > the instance page; you will need to wait five to ten minutes for the >> > instance list to appear. Not just the instance page, but also the place >> > where instances are listed out; for example, adding port forwarding or >> > listing instances running in VR everywhere they are the same. Is anyone >> > facing the same issue? >> > I checked the management log and saw that there was no error message and >> > that the management server's resource utilization was normal. . If >> someone >> > could provide some troubleshooting steps to identify the issue, that >> would >> > be very helpful. >> > >> > > > -- > With Regards, > Nixon Varghese
