Choosing an alarms database – Konica Minolta BIZHUB C30P User Manual
Page 26
Installing MetaConsole
page 12
Choosing an Alarms Database
MetaConsole ships with the HSQLDB database. This database stores the alarm (event) infor-
mation. The HSQLDB database is loaded into memory when the MetaConsole server starts
and records alarm information in a flat file in the MetaConsole directory.
The database adds alarm information at the rate of approximately 1000 events per megabyte.
Acknowledging all events increases the file size to approximately 500 events per megabyte,
but the database is optimized each time the MetaConsole server is started.The optimized da-
tabase stores alarm events at the rate of 2000 events per megabyte.
Performance is based largely upon the amount of RAM on your system. However, serious
degradation to server performance can occur once the database file size increases beyond 50
MB. The larger the database is, the longer it takes to load into memory when the MetaConsole
server starts. A 10 MB file can take several minutes to load.
You can save the HSQLDB database by copying and storing the database files MetaCon-
soleDB.data, MetaConsoleDB.properties, and MetaConsoleDB.script. You can create a
new database by deleting the old database files and running the runcreator.exe
application
in the MetaConsole directory.
If you prefer a more familiar and robust database, you can download and install one. The
MetaConsole server interfaces with Microsoft’s SQL database and MySQL database.The
Microsoft SQL database must be purchased and licensed but the MySQL database can be
downloaded free and used under a General Public License. For details about installation, see
“Installing MSSQL Database” on page 30 and “Installing MySQL Database” on page 31.