just cleaning up the vm_stats table in cloudstack 'cloud' db. > truncate table vm_stats;
and setting vm.stats.max.retention.time to a lower value addressed our issues. Joan On Tue, Feb 27, 2024 at 12:19 AM Andrei Mikhailovsky <and...@arhont.com.invalid> wrote: > Interesting. > > Joan, do you mind sharing how you are doing it? > > Thanks > > ----- Original Message ----- > > From: "Joan g" <joang...@gmail.com> > > To: "users" <users@cloudstack.apache.org> > > Sent: Monday, 26 February, 2024 18:06:58 > > Subject: Re: Slow Metrics output in GUI > > > I am facing the same problem in my 4.17.2 version. We are manually > clearing > > the stats table to make the instance list page load faster :( > > > > > > Joan > > > > On Mon, 26 Feb, 2024, 22:24 Andrei Mikhailovsky, > <and...@arhont.com.invalid> > > wrote: > > > >> Hello everyone, > >> > >> My setup: ACS 4.18.1.0 on Ubuntu 20.04.6. Two management servers and > mysql > >> active-active replication. > >> > >> > >> I seem to have a very slow response on viewing vms. It takes about 20 > >> seconds for the vm data to show when I click on any vm under Compute > > >> Instances. When I click on various vm tabs (like NICs, Disks, Details, > etc) > >> the only tab that takes about 15-20 seconds to refresh is the Metrics > tab. > >> When the spinner stops I get the following message: "No data to show for > >> the selected period." Also this information is shown in red colour: The > >> Control Plane Status of this instance is Offline. Some actions on this > >> instance will fail, if so please wait a while and retry. When I click on > >> the 12 or 24 hours tab it takes a bit of time, but it does show the > tables > >> and the message in red colour is not shown. > >> On mysql server I see the mysql process is using over 100% cpu (with 0% > >> iowait) while ACS tries to retrieve the Metrics data. Also, the > >> cloudstack-management server cpu usage goes to 200-400%. > >> > >> > >> I've tried all the obvious (restarting management servers, stopping one > of > >> the management servers, restarting host servers). > >> > >> Does anyone know what is the issue? why does it take so long to retrieve > >> the vm data and metrics? I don't remember having this problem before > 4.18. > >> > >> Many thanks for any pointers. > >> > >> cheers > >> > >> Andrei > >> > >> > >> > >> > >> > >> > >> >