MYSQL CLUSTER 7.2 +5.5创办磁盘表和内存表

2012-11-05

MYSQL CLUSTER 7.2 +5.5创建磁盘表和内存表?CREATE TABLE `City` (? `ID` int(11) NOTNULL auto_increment

MYSQL CLUSTER 7.2 +5.5创建磁盘表和内存表

CREATE TABLE `City` (

? `ID` int(11) NOTNULL auto_increment,

? `Name` char(35)NOT NULL default '',

? `CountryCode`char(3) NOT NULL default '',

? `District`char(20) NOT NULL default '',

? `Population`int(11) NOT NULL default '0',

? PRIMARY KEY? (`ID`)

) ENGINE=NDBCLUSTER DEFAULT CHARSET=latin1;

创建LOGFILE GROUP

create logfile group LGGP1_NDB ADD UNDOFILE'NDB_UNDO_01.dbf' INITIAL_SIZE=1073741824 ENGINE=NDBCLUSTER;

alter logfile group LGGP1_NDB ADD UNDOFILE 'NDB_UNDO_02.dbf'? INITIAL_SIZE=1073741824 ENGINE=NDBCLUSTER;

创建数据表空间组64mb -->1024*8

create tablespace TBS01_NDB ADD DATAFILE 'TBS01_DF_02.dbf'

? USE LOGFILE GROUPLGGP1_NDB

? EXTENT_SIZE=67108864 INITIAL_SIZE = 8589934592 AUTOEXTEND_SIZE = 67108864

? ENGINE =NDBCLUSTER;

alter tablespace TBS01_NDB ADD DATAFILE 'TBS01_DF_02.dbf'

?INITIAL_SIZE=8589934592 ENGINE=NDBCLUSTER;

.....

alter tablespace TBS01_NDB ADD DATAFILE 'TBS01_DF_10.dbf.dbf'?? INITIAL_SIZE=8589934592 ENGINE=NDBCLUSTER;