Users Guide

Embedded Database Sizing | Database Management
OMNM 6.5.3 Installation Guide 151
Follow these steps to resize your database
For Windows,
1 Shut down all applications and application server. And, if applicable, disconnect any other
processes from MySQL.
2 Stop the MySQL service on Windows with the command line: net stop mysql .
3 Edit the text file innodb_data_file_path in my.ini.
4 Add the new file path to innodb_data_file_path , for example:
Original:
innodb_data_file_path =d:/data/ibdata/ibdata1:600M:autoextend:max:2000M
To add the path f:/data/ibdata/ibdata2:200M, the new entry should be:
innodb_data_file_path = d:/data/ibdata/ibdata1:600M;f:/data/ibdata/
ibdata2:200M:autoextend:max:2000M
NOTE:
Case sensitivity is important here. Be sure to use uppercase “M's”. Omitting this prevents your database
from restarting
You must remove the initial , max and autoextend parameters from the initial line that
includes
ibdata1 . You must also set the file size to what it really is. To find the size of
ibdata1 run this command (in an command shell where you have already run oware in
Windows):
ls -lh /opt/dorado/..../ibdata1
In
my.cnf , using “1G” is acceptable. The line following this description of the original
volume describes the additional volume:
/opt/dorado/oware3rd/.../ibdata1:1G;
/opt/dorado/..../ibdata2:1024M:autoextend<optional params>
The MySQL Reference Manual for adding a data volume to a MySQL database is http://
dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html. See
MySQL Server
Configuration File Examples
on page 158 for other examples.
5 Save my.ini .
6 Start MySQL service on Windows by running net start mysql '. You should see the
following messages,
The MySql service is starting.
The MySql service was started successfully.
7 Check the file f:/data/ibdata/ibdata2 appears, and is the right size.