MySQL - How to create tablespaces for innodb engine
How can we create/configure tablespace for innodb engine?
We want to enable 'file per table' mode so that it creates .ibd file and saves data for all the tables - instead of using shared tablespace (default).
When we tried using set commands like as follows, its giving errors:
SET @df_path = 'file_dat';
SET @tbl_space_name ='file_dat';
CREATE tablespace @tbl_space_name
add datafile "@df_path"
engine = InnoDB;
Please help us regarding how we can create tablespaces using scripts.
Subject
Views
Written By
Posted
MySQL - How to create tablespaces for innodb engine
2480
April 24, 2013 01:20AM
822
April 24, 2013 02:25AM
735
April 24, 2013 09:55PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.