CAS modifies the monitoring data retention duration in the background

CAS E0526

The occupancy rate of the database partition /var/lib/mysql-share in CAS is 87%. There is an intention to temporarily avoid this by reducing the retention period of monitoring data. However, the minimum retention period for front - end monitoring data that can be modified is 3 days.

None

1. First, back up the data in /var/lib/mysql-share to the local machine.
2. Enter the database. The command reference is mysql -uroot -p1q2w3e@4R.
3. Enter the vservice database. The command reference is use vservice.
4. View the current monitoring data retention duration. The command reference is select * from TBL_PARAMETER where NAME='monitor.data.retain.time' .
5. Change the monitoring data retention duration to 1 day. The command reference is update TBL_PARAMETER set VALUE='1' where NAME='monitor.data.retain.time'.