List:Cluster« Previous MessageNext Message »
From:shrey.chen Date:April 19 2013 2:28am
Subject:Re:is there anyway to auto_extend a datafile?
View as plain text  
here is my config.ini

[TCP DEFAULT]
SendBufferMemory=4M
ReceiveBufferMemory=4M

[NDB_MGMD DEFAULT]
PortNumber=1186
Datadir=/data/mysqlcluster/

[NDB_MGMD]
NodeId=1
Hostname=192.168.200.21
LogDestination=FILE:filename=ndb_1_cluster.log,maxsize=10000000,maxfiles=6
ArbitrationRank=0

[NDBD DEFAULT]
NoOfReplicas=2
ServerPort=2200
Datadir=/data/mysqlcluster/
FileSystemPathDD=/data/mysqlcluster/
BackupDataDir=/data/mysqlcluster/backup/
#FileSystemPathUndoFiles=/data/mysqlcluster/
#FileSystemPathDataFiles=/data/mysqlcluster/
DataMemory=4520M
IndexMemory=565M
LockPagesInMainMemory=1

MaxNoOfConcurrentOperations=100000
MaxNoOfConcurrentTransactions=16384

StringMemory=25
MaxNoOfTables=4096
MaxNoOfOrderedIndexes=2048
MaxNoOfUniqueHashIndexes=512
MaxNoOfAttributes=24576
MaxNoOfTriggers=14336

### Params for REDO LOG 
FragmentLogFileSize=256M
InitFragmentLogFiles=SPARSE
NoOfFragmentLogFiles=18
RedoBuffer=48M

TransactionBufferMemory=8M

TimeBetweenGlobalCheckpoints=1000
TimeBetweenEpochs=100

TimeBetweenEpochsTimeout=0

### Params for LCP 
DiskCheckpointSpeedInRestart=100M
DiskCheckpointSpeed=10M
TimeBetweenLocalCheckpoints=20

### Heartbeating 
HeartbeatIntervalDbDb=15000
HeartbeatIntervalDbApi=15000

### Params for setting logging 
MemReportFrequency=30
BackupReportFrequency=10
LogLevelStartup=15
LogLevelShutdown=15
LogLevelCheckpoint=8
LogLevelNodeRestart=15

### Params for BACKUP 
BackupMaxWriteSize=1M
BackupDataBufferSize=24M
BackupLogBufferSize=16M
BackupMemory=40M

### Params for ODIRECT 
#Reports indicates that odirect=1 can cause io errors (os err code 5) on some systems. You must test.
#ODirect=1

### Watchdog 
TimeBetweenWatchdogCheckInitial=60000

### TransactionInactiveTimeout  - should be enabled in Production 
TransactionInactiveTimeout=60000
### New 7.1.10 redo logging parameters 
RedoOverCommitCounter=3
RedoOverCommitLimit=20
### REALTIME EXTENSIONS 
#RealTimeScheduler=1
### REALTIME EXTENSIONS FOR 6.3 ONLY
#SchedulerExecutionTimer=80
#SchedulerSpinTimer=40

### DISK DATA 
SharedGlobalMemory=20M
DiskPageBufferMemory=64M

### Multithreading 
MaxNoOfExecutionThreads=8

### Increasing the LongMessageBuffer b/c of a bug (20090903)
LongMessageBuffer=32M

BatchSizePerLocalScan=512
[NDBD]
NodeId=11
Hostname=192.168.200.21

### REALTIME ASPECTS - THREAD BINDING 
### READ http://johanandersson.blogspot.com/2008/02/mysql-cluster-features-what-they-are.html#realtime
#LockExecuteThreadToCPU=X
#LockMaintThreadsToCPU=Y

[NDBD]
NodeId=12
Hostname=192.168.200.61

### REALTIME ASPECTS - THREAD BINDING 
### READ http://johanandersson.blogspot.com/2008/02/mysql-cluster-features-what-they-are.html#realtime
#LockExecuteThreadToCPU=X
#LockMaintThreadsToCPU=Y

[MYSQLD DEFAULT]
DefaultOperationRedoProblemAction=QUEUE
BatchSize=512
#BatchByteSize=2048K
#MaxScanBatchSize=2048K

[MYSQLD]
NodeId=51
[MYSQLD]
NodeId=52
[MYSQLD]
NodeId=53
[MYSQLD]
NodeId=54

[MYSQLD]
NodeId=55
[MYSQLD]
NodeId=56
[MYSQLD]
NodeId=57
[MYSQLD]
NodeId=58

[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
### SLOTS (one for each ndb_mgmd) FOR HELPER APPLICATIONS SUCH AS ndb_show_tables etc
[MYSQLD]
Hostname=192.168.200.21
### SLOT FOR CMON
[MYSQLD]
Hostname=192.168.200.61




------------------ Original ------------------
From:  "shrey.chen"<434483587@stripped>;
Date:  Fri, Apr 19, 2013 10:20 AM
To:  "cluster"<cluster@stripped>; 

Subject:  is there anyway to auto_extend a datafile?



hi,

     i am a newbie of mysql cluster.
     i set up a cluter from "mysql-cluster-gpl-7.2.10-debian6.0-x86_64.deb"

     here is the problem when i tested the 'disk data table'.
     i dump a database named 'news' from my standard sqlserver,it only contained one table named 'news_cr_news' and its size is 2.4G
         -rw-rw---- 1 mysql mysql 2.4G 2011-02-26 news_cr_news.MYD.
     so i create a tablespace that contained two datafiles,one's size is 1G,the other 2G, and i thought that was enough.
     when i loaded data into the cluster, i got an error as follow:
ERROR 1114 (HY000): The table 'news_cr_news' is full
mysql> show warnings;
+---------+------+--------------------------------------------------------+
| Level   | Code | Message                                                |
+---------+------+--------------------------------------------------------+
| Warning | 1296 | Got error 1601 'Out extents, tablespace full' from NDB |
| Error   | 1114 | The table 'news_cr_news' is full                       |
+---------+------+--------------------------------------------------------+
2 rows in set (0.00 sec)

and the informations of files are:

mysql> select FILE_NAME,INITIAL_SIZE,TABLESPACE_NAME,FREE_EXTENTS,TOTAL_EXTENTS,MAXIMUM_SIZE from FILES;
+---------------------+--------------+-----------------+--------------+---------------+--------------+
| FILE_NAME           | INITIAL_SIZE | TABLESPACE_NAME | FREE_EXTENTS | TOTAL_EXTENTS | MAXIMUM_SIZE |
+---------------------+--------------+-----------------+--------------+---------------+--------------+
| diskdata/news_2.dat |   2147483648 | news_ts         |            0 |          2048 |   2147483648 |
| diskdata/news_2.dat |   2147483648 | news_ts         |            0 |          2048 |   2147483648 |
| diskdata/news_1.dat |   1073741824 | news_ts         |            0 |          1024 |   1073741824 |
| diskdata/news_1.dat |   1073741824 | news_ts         |            0 |          1024 |   1073741824 |
| NULL                |         NULL | news_ts         |         NULL |          NULL |         NULL |
| undologs/news_1.log |    134217728 | NULL            |         NULL |      33554432 |    134217728 |
| undologs/news_1.log |    134217728 | NULL            |         NULL |      33554432 |    134217728 |
| NULL                |         NULL | NULL            |     33505296 |          NULL |         NULL |
+---------------------+--------------+-----------------+--------------+---------------+--------------+
8 rows in set (0.01 sec)

here i found a column named 'AUTOEXTEND_SIZE',
so, Is there a way to auto_extend a datafile from the initial size ?
Thread
Re:is there anyway to auto_extend a datafile?shrey.chen19 Apr