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

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.