Re: How to create table data on disk rather then in memory

[Jitender Singh]

Hi Jon,

I got my answer of 1 & 3 questions.

Ans 1. Yes, we do have parameter to put in config file. For creating log group and assign logfile name. Creating tablespace and assign data file and log group.

FileSystemPathDD - MySQL Cluster Disk Data data files and undo log files are placed in the indicated directory.

FileSystemPathDataFiles - MySQL Cluster Disk Data data files are placed in the indicated directory.

FileSystemPathUndoFiles - MySQL Cluster Disk Data undo log files are placed in the indicated directory


Ans 3. InitialLogFileGroup & InitialTablespace - These two parameters will start the cluster for the first time—to cause a Disk Data log file group, tablespace, or both, to be created without the use of SQL statements.

for eg :

InitialLogFileGroup = name=LG1; undo_buffer_size=128M; undo1.log:250M; undo2.log:150M

InitialTablespace = name=TS1; extent_size=8M; data1.dat:2G; data2.dat:4G


Here again I have question, the log file and data file will grow only till the size we specified, What if my log file or data file will expected to grow more then that.

If I have to set for 1TB of database size?



Edited 1 time(s). Last edit at 10/09/2016 02:54PM by Jitender Singh.