Hello, Andrei and Joan
The values for the configurations *vm.stats.max.retention.time* and
*vm.stats.interval* will impact in required storage space as well as in
the DB performance; their default values may not be ideal depending on
the environment, especially larger ones. For this reason, the section
*Instance Metrics* in ACS documentation was added [1], that better
explain their impacts. The doc presents an equation for calculating the
storage space required for only the *vm_stats* table, which roughly
reflects the DB performance.
[1]:
http://docs.cloudstack.apache.org/en/latest/adminguide/virtual_machines.html#instance-metrics
On 06/03/2024 08:07, Andrei Mikhailovsky wrote:
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
