Product Name
CIS-CAT Pro Dashboard
Product Version
v3.x.x+
Date
Problem
Info |
---|
The imports to my Dashboard instance were initially very fast, ~20 seconds/report. However, after several thousand imports the import time increases to as much as [for example] 9 minutes per report. |
Solution
In this order, please first:
Increase the
Java Memory Pool
by navigating toC:\Program Files\CCPD\CIS-CAT Pro Dashboard.vmoptions
orusr/local/CCPD/CIS-CAT Pro Dashboard.vmoptions
and double this number or more.Every environment is different and you may need to experiment with a higher number and then decrease to find the right spot for your uploads
Compress/ zip the reports sent to Dashboard. If you have not already, in your
Assessor-CLI.properties
file, located in yourAssessor-CLI\config
directory around line 108 change this fromfalse
totrue
Code Block # Allow for assessment reports to be zipped/compressed when they are sent to the Dashboard via a POST request # This property is only supported with Dashboard version 1.1.9 or higher. ciscat.zip.post.files=true
Restart the
CCPD
andMariaDB
services and test
A member’ took a look at CIS-CAT Pro Dashboard’s ingestion speeds and they came up with a solution. This member’s import time Members have found that import times for a multitude of reports has been greatly improved with a modification to the
my.ini
fileStop CCPD and MariaDB services
If desired: Create a backup of the file, rename or remove backup from dir.
C:\Program Files\CCPD\mariaDB\server\my.ini
Open the
my.ini
file in a text editing program, add 2 lines to themy.ini
file below the following line
The member used 16gb, however this can be adjusted based on your system’s resources to suit your needs and resources*Code Block [mysqld] datadir=C:/Program Files/CCPD/mariaDB/server
as shown below
Code Block [mysqld] datadir=C:/Program Files/CCPD/mariaDB/server innodb-buffer-pool-size=16G max_allowed_packet=512M [client] plugin-dir=C:\Program Files\CCPD\mariaDB\windows_unzip\mariadb-10.6.8-winx64/lib/plugin
Save the file
Restart services
Validate Maria DB is running
Note |
---|
* One member noticed that the RAM usage on the Dashboard server would spike to 100% and the
This lower buffer pool size was more stable for this specific end-user. |
Keywords;
Content by Label
Filter by label (Content by label) | ||||||
---|---|---|---|---|---|---|
|
Page Properties | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||
|