MySQL Forums
Forum List  »  NDB clusters

Re: Pls help me for MySQL Cluster 5.1.14 ITS URGENT
Posted by: Stewart Smith
Date: January 28, 2007 07:01PM

> Q.1 can we store data in RAM or in DISK whenever we want, in cluster 5.1?

non-indexed data can be stored on disk in 5.1

> Q.2 how can we identify that this table is stored in RAM or Disk???

SHOW CREATE TABLE will tell you. or you can use the ndb_desc tool to see which fields exactly are stored in memory/on disk.

> Q.3 I have crated log file, tablespace. but when i have created a file and insert the records in that file then that records has been stored in RAM why? I have also used TABLESPACE <tablespace_name> STORAGE DISK when we create table.

indexed fields must be stored in memory. this could be it.

> Q.4 If first i have made table in memory then now i have to transfer that table from memory to disk then how can i????

ALTER TABLE t1 ENGINE=NDB TABLESPACE ts1 STORAGE DISK;
(this is a copying alter table)

Stewart Smith, Software Engineer - MySQL Cluster
MySQL AB, www.mysql.com

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Pls help me for MySQL Cluster 5.1.14 ITS URGENT
1106
January 28, 2007 07:01PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.