Hi, Sure I will keep an eye on it... This is more helpful, thank you...
With regards, Nixon Varghese On Thu, Jun 20, 2024 at 5:01 PM Andrei Mikhailovsky <and...@arhont.com.invalid> wrote: > 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 > > -- With Regards, Nixon Varghese
