Users Guide

Optimizing Your System | Getting Started
OMNM 6.5.3 User Guide 115
For example, if you have 16 polled data attributes and 27 calculated attributes, not
saving polled data can reduce the table size about 35%.
You can further reduce the table size if you only poll/save the relevant calculated
attributes in the default SNMP interface monitor. To accomplish this you must remove
calculated/polled attributes that you do not want to retain from the monitor
configuration, OpenManage Network Manager does not support selectively choosing
which attributes to keep. Retained attributes can be all calculated or no calculated.
NOTE:
Best practice is to archive the modified database sizing file somewhere safe. Upgrading or patching your
installation may overwrite your settings, and you can simply copy the archived file to the correct location
to recover any configuration you have made if that occurs.
If you want to change the size of your database after you have installed it, edit the my.cnf file in /
oware3rd/mysql/[version number]/
. Alter the last number on the following line:
[path]/oware3rd/mysql/ibdata/ibdata1:1024M:autoextend:max:102400M
To start MySQL, run the following in a shell:
[path]oware3rd/MySQL/[version number]/bin/mysqld" --console
When it starts successfully, the console includes a ready for connections message. Without
the
--console parameter, MySQL writes diagnostic output to the error log in its data directory.
To stop MySQL, run the following in a shell on the path with MySQL:
mysqladmin shutdown
Other operating system-specific shutdown initiation methods are possible as well: The server shuts
down on Linux when it receives a SIGTERM signal. A server running as a service on Windows
shuts down when you shut it down in Windows’ services manager.
NOTE:
The default MySQL login command line is: >mysql -u root --password=dorado