InterSystems IRIS Backup mirror member is very slow
Hi All,
When I log into Backup mirror member it becomes too slow to load and navigate, I tried to check message log and I saw the error message about Database mirror latency and database disk issue which when I check it looks fine to me. Please have a look at the below screenshots and advise what the issue could be.
When I run df -h through SSH :
200G is the volume size, 194G is used space, 6.5G is available space and 97% IS %Use
.png)
Datababase view from management portal for the same db volume
.png)
Disk space error message from message log:
.png)
The below error shows sometimes when the system tries to load
.png)
Product version: IRIS 2020.2
$ZV: HealthShare 2020.2 [HealthShare Modules: Active Analytics:20.0.8620 + Core:20.0.8620 + Patient Index:20.0.8620] - IRIS for UNIX (Red Hat Enterprise Linux for x86-64) 2020.1 (Build 217_1_20418U) Tue Nov 17 2020 15:48:44 EST
Hello Ephraim,
This seems like a better question for InterSystems Support / WRC who can look at the full log and system to try and determine what's happening.
From a file system disk space perspective, the database is almost filling the disk, but there is free space WITHIN the database from the IRIS perspective.
Regarding the performance side of things, what did you check such that it looks fine? CPU / memory / disk? When did the warnings start and are they ongoing? What's being done on the system, anything abnormal?
Ephraim,
Does the top command show a large swap space. I have seen backup servers with a smaller physical memory get the programs into swap space which as you know is extremely slow to operate.
John
Hello Ephraim,
your database is 193GB and has 141GB of free space (73% free). There is a 6.5GB space on the OS file system,
I recommend you to:
- Compact globals in database
- Compact free space ibn database
- Return free space in database
All those can be done when you do the following:
%SYS>do ^DATABASE