作者：NANA-LS | 来源：互联网 | 2023-09-18 11:47
createatablewithtablespaceset.
create a table with tablespace set.
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)
京公网安备 11010802041100号