將MyISAM的table格式轉換為cluster格式
mysql> ALTER TABLE table1 ENGINE=NDBCLUSTER;
Query OK, 2 rows affected (0.96 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> show create table `table1`;
+--------+------------------------------------
| Table | Create Table
+--------+------------------------------------
| table1 | CREATE TABLE `table1` (
`a` int(11) DEFAULT NULL
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 |
+--------+------------------------------------
1 row in set (0.01 sec)
-rw-rw---- 1 mysql mysql 8554 Aug 11 15:34 table1.frm
-rw-rw---- 1 mysql mysql 0 Aug 11 15:34 table1.ndb
-rw-rw---- 1 mysql mysql 8554 Aug 11 15:05 table2.frm
-rw-rw---- 1 mysql mysql 0 Aug 11 15:05 table2.ndb
- Aug 11 Wed 2010 15:37
MySQL Cluster 測試筆記 (轉換table格式to ndbcluster)
全站熱搜
留言列表
發表留言