Product Name
CIS-CAT Pro Dashboard
Product Version
v3.x.x+
Date
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.
Please begin by reviewing these 3 suggestions which are less invasive ?means of increasing your CIS-CAT Pro Dashboard’s import/ upload speeds
Solution
A member’s DBAs took a look at CIS-CAT Pro Dashboard’s ingestion speeds and they came up with a potential fix. This member’s import time for a multitude of reports has been greatly improved with a modification to the my.ini file
Stop 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.inifile in a text editing program, add 2 lines to themy.inifile below the following line[mysqld] datadir=C:/Program Files/CCPD/mariaDB/server
The member used 16gb, however this can be adjusted based on your system’s resources to suit your needs and resources*
[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
* 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.
Add Comment