2 messages in com.mysql.lists.clusterRe: Help about save tables on disk
FromSent OnAttachments
Tarcisio Layme20 Oct 2007 18:06 
Stewart Smith21 Oct 2007 17:55 
Subject:Re: Help about save tables on disk
From:Stewart Smith (stew@mysql.com)
Date:10/21/2007 05:55:17 PM
List:com.mysql.lists.cluster

On Sun, 2007-10-21 at 02:07 +0100, Tarcisio Layme wrote:

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

I gather you mean *5*.0.22

################################### 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.

What error do you get? On the same SQL node? Any warnings from the previous statements?

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

no.

-- Stewart Smith, Senior Software Engineer MySQL AB, www.mysql.com Office: +14082136540 Ext: 6616 VoIP: 66@sip.us.mysql.com Mobile: +61 4 3 8844 332

Jumpstart your cluster: http://www.mysql.com/consulting/packaged/cluster.html