MYSQLCLUSTER7.2 + 5.5 create disk table and memory table _ MySQL
Source: Internet
Author: User
MYSQLCLUSTER7.2 + 5.5 create disk table and memory table bitsCN.com
Mysql cluster 7.2 + 5.5 CREATE a disk TABLE and a memory table create a memory TABLE and a disk TABLE on the mysql cluster created in the memory TABLE method: CREATE a memory table create table 'City' ('id' int (11) not null 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; disk tables are different. you need to create UNDO tablespaces, and create LOGFILE GROUPcreate 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; create data table space GROUP 64 mb --> 1024*8 create tablespace TBS01_NDB add datafile 'tbs01 _ df_02.dbf' use logfile group LGGP1_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; a bug occurs when the unit of data file size is m when the value is 7.2 + 5.5, * After 1024*1024, the TABLE can be created after the data is added. the partition TABLE does NOT support create table 'City' ('id' int (11) not null 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') TABLESPACE TBS01_NDB storage disk engine = ndbcluster default charset = latin1 bitsCN.com
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.