Description:
1 data node
1 mysqld
[ndbd default]
datadir=/data2/users/johan/datadir
NoOfReplicas=1 # Number of replicas
DataMemory=6250M # How much memory to allocate for data storage
IndexMemory=250M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.
HeartbeatIntervalDbDb=600
HeartbeatIntervalDbApi=600
#MaxNoOfConcurrentOperations=125000
MaxNoOfConcurrentOperations=65536
#MaxNoOfConcurrentTransactions=10000
MaxNoOfConcurrentTransactions=4096
TimeBetweenWatchDogCheck = 40000
#TimeBetweenLocalCheckpoints=16
TimeBetweenLocalCheckpoints=20
#NoOfFragmentLogFiles=586
NoOfFragmentLogFiles=611
MaxNoOfOrderedIndexes = 500
#MaxNoOfTables=9000
MaxNoOfTables=1000
MaxNoOfAttributes = 25000
#DiskPageBufferMemory=32M
DiskPageBufferMemory=128M
#SharedGlobalMemory=512M
SharedGlobalMemory=128M
How to repeat:
mysql>CREATE LOGFILE GROUP lg_1 ADD UNDOFILE 'undo_1.dat' INITIAL_SIZE 6G UNDO_BUFFER_SIZE 64M ENGINE NDB;
mysql> CREATE TABLESPACE ts_1 ADD DATAFILE 'data_1.dat' USE LOGFILE GROUP lg_1 INITIAL_SIZE 12G ENGINE=NDB;
mysql> drop tablespace ts_1 engine ndb;
ERROR 1517 (HY000): Failed to drop TABLESPACE
mysql> show errors;
+-------+------+-----------------------------------------------------------------+
| Level | Code | Message |
+-------+------+-----------------------------------------------------------------+
| Error | 1296 | Got error 768 'Cant drop filegroup, filegroup is used' from NDB |
| Error | 1517 | Failed to drop TABLESPACE |
+-------+------+-----------------------------------------------------------------+
2 rows in set (0.00 sec)
© 2025, Oracle Corporation and/or its affiliates
Description: 1 data node 1 mysqld [ndbd default] datadir=/data2/users/johan/datadir NoOfReplicas=1 # Number of replicas DataMemory=6250M # How much memory to allocate for data storage IndexMemory=250M # How much memory to allocate for index storage # For DataMemory and IndexMemory, we have used the # default values. Since the "world" database takes up # only about 500KB, this should be more than enough for # this example Cluster setup. HeartbeatIntervalDbDb=600 HeartbeatIntervalDbApi=600 #MaxNoOfConcurrentOperations=125000 MaxNoOfConcurrentOperations=65536 #MaxNoOfConcurrentTransactions=10000 MaxNoOfConcurrentTransactions=4096 TimeBetweenWatchDogCheck = 40000 #TimeBetweenLocalCheckpoints=16 TimeBetweenLocalCheckpoints=20 #NoOfFragmentLogFiles=586 NoOfFragmentLogFiles=611 MaxNoOfOrderedIndexes = 500 #MaxNoOfTables=9000 MaxNoOfTables=1000 MaxNoOfAttributes = 25000 #DiskPageBufferMemory=32M DiskPageBufferMemory=128M #SharedGlobalMemory=512M SharedGlobalMemory=128M How to repeat: mysql>CREATE LOGFILE GROUP lg_1 ADD UNDOFILE 'undo_1.dat' INITIAL_SIZE 6G UNDO_BUFFER_SIZE 64M ENGINE NDB; mysql> CREATE TABLESPACE ts_1 ADD DATAFILE 'data_1.dat' USE LOGFILE GROUP lg_1 INITIAL_SIZE 12G ENGINE=NDB; mysql> drop tablespace ts_1 engine ndb; ERROR 1517 (HY000): Failed to drop TABLESPACE mysql> show errors; +-------+------+-----------------------------------------------------------------+ | Level | Code | Message | +-------+------+-----------------------------------------------------------------+ | Error | 1296 | Got error 768 'Cant drop filegroup, filegroup is used' from NDB | | Error | 1517 | Failed to drop TABLESPACE | +-------+------+-----------------------------------------------------------------+ 2 rows in set (0.00 sec)