2 messages in com.mysql.lists.clusterHelp about save tables on disk| From | Sent On | Attachments |
|---|---|---|
| Tarcisio Layme | 20 Oct 2007 18:06 | |
| Stewart Smith | 21 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




