Raw Devices For Shared Tablespace

• Raw disk partitions can be used as data files in the shared tablespace.

• When creating a new data file, one 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 specified size.

    [mysqld]
    

    innodb_data_home_dir=
    

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

• The newraw keyword initializes the new partition.
  • Once the server is restarted and the partition is initialized, change the my.cnf file to:
    [mysqld]
    
    innodb_data_home_dir=
    
    innodb_data_file_path=/dev/hdd1:3Graw;/dev/hdd2:2Graw

What are some InnoDB system variables?

---

---

© 2007 John Michael Pierobon

Notes