How can I improve the speed of imports into CIS-CAT Pro Dashboard v3?
Product Name
CIS-CAT Pro Dashboard
Product Version
v3.x.x+
Date
Apr 3, 2024
Problem
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
# 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
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
as shown below[mysqld] datadir=C:/Program Files/CCPD/mariaDB/server innodb-buffer-pool-size=16G max_allowed_packet=512M
Save the file
Restart the
CCPD
andMariaDB
services
One member noticed that the RAM usage on the Dashboard server would spike to 100% and the CCPD
service would intermittently stop. By putting in the "innodb-buffer-pool-size=16G
" they were not allotting enough RAM for other system tasks. This member updated the my.ini file with:
innodb-buffer-pool-size=12G
This lower buffer pool size was more stable for this specific end-user.
Keywords;
Content by Label