2 messages in com.mysql.lists.clusterHelp about save tables on disk
FromSent OnAttachments
Tarcisio Layme20 Oct 2007 18:06 
Stewart Smith21 Oct 2007 17:55 
Subject:Help about save tables on disk
From:Tarcisio Layme (tla@msn.com)
Date:10/20/2007 06:06:37 PM
List:com.mysql.lists.cluster

I need create and save table and data on hard disk, using Mysql 6.0.22. I do
this using this model:

################################### Basic test of disk tables for NDB# Start by
creating a logfile group##################################CREATE LOGFILE GROUP
lg1ADD UNDOFILE 'undofile.dat'INITIAL_SIZE 16MUNDO_BUFFER_SIZE =
1MENGINE=NDB;#################################################### Create a
tablespace connected to the logfile
group###################################################CREATE TABLESPACE ts1ADD
DATAFILE 'datafile.dat'USE LOGFILE GROUP lg1INITIAL_SIZE 12MENGINE
NDB;######################################### Create a table using this
tablespace########################################CREATE TABLE t1(pk1 INT NOT
NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL)TABLESPACE ts1 STORAGE
DISKENGINE=NDB; But when i try open the table they don't show.

I create logfile and tablespace on one node (SQL node). I must create logfile
and tablespace on each storage node?pls help me.

_________________________________________________________________ Veja mapas e encontre as melhores rotas para fugir do trânsito com o Live Search
Maps! http://www.livemaps.com.br/index.aspx?tr=true