H2 database size
I am curious what is the expected size of the DB, (# of nodes/ DB size ratio)
PMS10.01 is installed on VM Win 2003 server
For roughly 1400 nodes DB reached already 17GB, whie the last Friday it was "barely" 15GB.
Since it is a Virtual machine I can at least easily resize its hard drives, but would be nice to know if anything can be done to control the DB growth.
I was not paying attention to DB size until I noticed significant reduction of the free space on the drive where the PMS is installed.
Is there any tool permitting to shrink the DB size?
Is there any recommended configuration to limit the amount of information it stores?
TIA
Andrzej
Comments
-
The Database also holds the imported JARs!
Still 17GB sounds pretty much!
What Version/Platform is your PMS?
0 -
Already mentioned in my original posting
here are additional details
PMC/PMS 10.01.40601
VirtualMachine resides on Windows 2003 Std SP2
2 CPUs @ 2.53GHz, 4 GB Ram
It looks that each start of the PMC or even server's reboot contributes to the DB size increase
DB growth recorded over the last few days
Friday 15.7 GB
Monday morning 17.5 GB
Monday afternoon 18.4 GB
on Monday HD size was increased from 30 GB to 40 GB and server was rebooted couple of times
Tuesday remains at 18.4 GB
0 -
Check the logfiles for extreme communication from a single client that might have gone crazy...
0 -
Hi Andrzej,
As advice from Matthias have you clean up unwanted old .jar files from the PM10.01?
The other option that you can try is to remove the old alert and scanning report.
Policy manager console > Alert tab > Remove most of the unwanted alert.
Policy manager console > Scanning report tab > Remove most of the unwanted alert.
Andy
0 -
In general I do not keep too many jar files (only those I might/will need)
After detecting the high DB size few weeks ago I configured Alerts and Reports to very high value (exceeding the oldest reports kept on the server) and I keep deleting reports/alerts older than 10 days.
This did not make big impact on the DB size (1GB overall)
Currently it is sitting t almost 20GB
Does PMC offer a setting to autopurge older alerts/reports?
How about history of downloaded updates etc?
Andrzej
0 -
Hi Andrzej,
Does PMC offer a setting to autopurge older alerts/reports?
How about history of downloaded updates etc?
There is no option to auto remove the Alerts and Reports, the only option is to hied the alert. It have to be remove manually.
This tools will flush all the history update and the current update from the PM, but it will redownload back again.
ftp://ftp.f-secure.com/support/tools/FSAUA-Reset/fsaua-reset.exe
Please also try to PM Console > Tools > Preferences > Push install tab > Clear Cache.
Andy
1 -
Andy I followed your recommendations (including running of the tool)
The outcome is not very promissing. After rebooting the DB is now 18.4GB.
I need more help in troubleshooting the source of the DB growth
Andrzej
0 -
Hello,
Regrettably, anything PM's AUA/AUS downloads is stored triplicated, therefore rapidly occupying really large storage areas. If there are only Windows computers in the affected network, then it is unneeded to download the for-Linux antivirus database variants. So maybe prune the corresponding config file. This is not official, but saves a lot of space and the attached instructions picture was provided by F-Secure staff.
1 -
When removing alerts and reports, did you first unselect "hide older alerts/reports"?
I am really wondering what makes you H2DB that size.
Signature Updates are not stored in the H2DB!JAR files are stored there. So you should remove all unneeded instrallation packages. They are only needed if you want to install a new host, not for management!
BR
0 -
In the past I needed to uninstall F-S software from workstations which left
Are you saying that jar files are not needed for that transaction?
Initialy I set filter to a very large number (was not certain if the unslecting will do the same)
Concluding all older reports and alerts were removed from the history
0 -
Hi Andrej,
Only the latest jar files is needed for the PM transaction, the older version is not important. Please update us what is the total size of F-Secure folder on program files?
Andy
0 -
Just few jar files were left, I removed all the alerts and reports older than 2 days, DB size remained unchanged at 18.5 GB
Andrzej
0 -
Total F-Secure folder size (with all the subdirectories) is 25 GB
0 -
Andrej,
Thank you for the details on folder size, I will need to check with the h2db once you send to the designated F-Secure ftp. We will update you on the support case.
Andy
0 -
Go to PM console, open Tools, Preferences, Push Installations, Clear cache
0 -
@dragos wrote:Go to PM console, open Tools, Preferences, Push Installations, Clear cache
Thanks dragos,
As a matter of fact problem with constantly growing DB was resolved somehow with upgrading Policy Management Console (unfortunately I do not recall if it was to the lastest 10.x or 11)
Andrzej
5
Categories
- All Categories
- 3.5K WithSecure Community
- 3.5K Products
- Get Support