Users Guide

Embedded Database Sizing | Database Management
152 OMNM 6.5.3 Installation Guide
For Linux
1 Shut down all applications and application server. And also disconnect any other process
connected to MySQL.
2 Stop the MySQL server process by running the following command:
mysqladmin -h <DBServerName> --user=root --password=<RootUserPassword>
shutdown'
For example, if DBServerName is nova , RootUserPassword is dorado :
mysqladmin -h nova --user=root --password=dorado shutdown'
If that command fails, run the following command:
$MYSQL_ROOT/support-files/mysql.server stop
3 Log on as the root user and use a text editor like vi to open /ect/my.cnf.
4 Locate the entry innodb_data_file_path in my.cnf .
5 Add the new file path to innodb_data_file_path, for example,
Original:
innodb_data_file_path = /data1/ibdata/ibdata1:600M:autoextend:max:2000M
To add the path /data2/ibdata/ibdata2:200M, the new entry should be:
innodb_data_file_path = /data1/ibdata/ibdata1:600M;/data2/ibdata/
ibdata2:200M:autoextend:max:2000M
NOTE:
Remove the remove the initial, max and autoextend parameters from the initial line that includes ibdata1,
as described in the Tip for Windows.
6 Save my.cnf
7 Log on as an authorized user to start MySQL server process as mysqld_safe .
NOTE:
You may need to specify the path for mysqld_safe.
You should see messages indicating MySQL server started successfully.
8 Check the file /data2/ibdata/ibdata2 appears, and is the right size.
Modifying the MySQL FAT File Systems
If you have upgraded from older operating systems you may still have a FAT file system that limits
your database size or expansion beyond 2GB. The database is a file as far as the operating system is
concerned, and FAT limits file size. There is also a 4GB limit on early versions of NTFS that may
linger because of upgrades.
To change the installed database sizes, you must edit the configuration file:
•Windows:
%SystemRoot%\my.ini
The origin of the configuration in the several my.cnf files on Linux is a path like /opt/dorado/
oware3rd/mysql/5.0.51-pc-linux-i686-64/my.cnf
, so be sure to alter that one if you
are reconfiguring OpenManage Network Manager’s MySql.The following line controls maximum
database size (at end):