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 >> >> >> >> >> >> >>