> 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