ivaneeo's blog

自由的力量,自由的生活。

  BlogJava :: 首页 :: 联系 :: 聚合  :: 管理
  669 Posts :: 0 Stories :: 64 Comments :: 0 Trackbacks
5.1.37-ndb-7.0.8a-cluster-gpl MySQL Cluster Server (GPL) 

create a table with tablespace set. 

* tablespace creation * 
CREATE TABLESPACE ts_1 ADD DATAFILE '/home/db/mysql-cluster/data/data_1.dat' USE LOGFILE GROUP lg_1 INITIAL_SIZE = 26843545600 ENGINE NDB; 
ALTER TABLESPACE ts_1 ADD DATAFILE '/home/db/mysql-cluster/data/data_2.dat' INITIAL_SIZE 26843545600 ENGINE NDB; 
ALTER TABLESPACE ts_1 ADD DATAFILE '/home/db/mysql-cluster/data/data_3.dat' INITIAL_SIZE 26843545600 ENGINE NDB; 
ALTER TABLESPACE ts_1 ADD DATAFILE '/home/db/mysql-cluster/data/data_4.dat' INITIAL_SIZE 26843545600 ENGINE NDB; 


* table creation * 
CREATE TABLE `TABLE` ( 
`A` date NOT NULL, 
`B` varchar(30) NOT NULL, 
`C` varchar(50) NOT NULL, 
`D` varchar(50) NOT NULL, 
`E` varchar(50) NOT NULL, 
`F` varchar(255) DEFAULT NULL 
) TABLESPACE ts_1 STORAGE DISK ENGINE=ndbcluster DEFAULT CHARSET=utf8 


PK, index generated without the table and insert the data(40G), 
I'm Using logs as the following index numbers are still high. (mgm log) 
The actual number of memory ndb also giving you an upward trend ... Why? 


2009-11-17 16:54:58 [MgmtSrvr] INFO -- Node 8: Index usage is 4%(30707 8K pages of total 655392) 
2009-11-17 16:55:25 [MgmtSrvr] INFO -- Node 8: Data usage is 8%(20603 32K pages of total 229376)
posted on 2014-12-23 20:57 ivaneeo 阅读(426) 评论(0)  编辑  收藏 所属分类: GNU牛力

只有注册用户登录后才能发表评论。


网站导航: