Thanks Joan, I have updated vm.stats.max.retention.time value to 60 to see if this resolves my slow performance.
Cheers ----- Original Message ----- > From: "Joan g" <joang...@gmail.com> > To: "users" <users@cloudstack.apache.org> > Sent: Tuesday, 27 February, 2024 10:01:05 > Subject: Re: Slow Metrics output in GUI > 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 >> >> >> >> >> >> >> >> >> >> >> >> >> >>