MySQL-5.1.26-rc-cluster 测试1

批量导入时:

[root@sql1 script]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2186
Server version: 5.1.26-rc-cluster-gpl MySQL Cluster Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database ff;
Query OK, 1 row affected (0.31 sec)

mysql> use ff;
Database changed
mysql> source /a.sql;
ERROR:
Failed to open file '/a.sql', error: 2
mysql> source /script/a.sql;
ERROR 1005 (HY000): Can't create table 'ff.test10' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test11' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test12' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test13' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test14' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test15' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test16' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test17' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test18' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test19' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test20' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test21' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test22' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test23' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test24' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test25' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test26' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test27' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test28' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test29' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test30' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test31' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test32' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test33' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test34' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test35' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test36' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test37' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test38' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test39' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test40' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test41' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test42' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test43' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test44' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test45' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test46' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test47' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test48' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test49' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test50' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test51' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test52' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test53' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test54' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test55' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test56' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test57' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test58' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test59' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test60' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test61' (errno: 708)
ERROR 1005 (HY000): Can't create table 'ff.test62' (errno:

发现问题:
mysql> show variables like 'have%';
+-------------------------+-------+
| Variable_name           | Value |
+-------------------------+-------+
| have_community_features | NO    |
| have_compress           | YES   |
| have_crypt              | YES   |
| have_csv                | YES   |
| have_dynamic_loading    | YES   |
| have_geometry           | YES   |
| have_innodb             | NO    |
| have_ndbcluster         | YES   |
| have_openssl            | NO    |
| have_partitioning       | YES   |
| have_query_cache        | YES   |
| have_rtree_keys         | YES   |
| have_ssl                | NO    |
| have_symlink            | YES   |
+-------------------------+-------+
14 rows in set (0.02 sec)
处理
修改 engine