Mysql InnoDB TABLESPACE Set Up [二] using raw disk

Using Raw Devices for the Tablespace:

In MySQL 5.0,can use raw disk partitions as tablespace data files.

step1:

       When you create a new data file, you must put the keyword newraw immediately after the data file size in innodb_data_file_path. The partition must be at least as large as the size that you specify.

[mysqld]

innodb_data_home_dir=

innodb_data_file_path=/dev/hdd1:3Gnewraw;/dev/hdd2:2Gnewraw

step2:

       you start the server, InnoDB notices the newraw keyword and initializes the new partition. However, do not create or change any InnoDB tables yet.[notice]

step3:

After InnoDB has initialized the new partition, stop the server, change newraw in the data file specification to raw:

[mysqld]

innodb_data_home_dir=

innodb_data_file_path=/dev/hdd1:5Graw;/dev/hdd2:2Graw

step4:

       Then restart the server and InnoDB allows changes to be made.

[notice]

On Windows, you can allocate a disk partition as a data file like this:

[mysqld]

innodb_data_home_dir=

innodb_data_file_path=//./D::10Gnewraw

The //./ corresponds to the Windows syntax of \\.\ for accessing physical drives.