mysql> insert into Billinfo values('',456,123456789,130282,222,333,'2012.3.24','2057','40','2','38','xianjin',444);
ERROR 1114 (HY000): The table 'Billinfo' is full
这时看表数据条数才53万条
mysql> select count(1) from Billinfo;
+----------+
| count(1) |
+----------+
| 537007 |
+----------+
磁盘空间也没满：
mysql> SELECT TABLESPACE_NAME, FILE_NAME, EXTENT_SIZE*TOTAL_EXTENTS/1024/1024 AS TOTAL_MB, EXTENT_SIZE*FREE_EXTENTS/1024/1024 AS FREE_MB, EXTRA FROM information_schema.FILES WHERE FILE_TYPE="DATAFILE";
+-----------------+------------+----------------+---------------+----------------+
| TABLESPACE_NAME | FILE_NAME | TOTAL_MB | FREE_MB | EXTRA |
+-----------------+------------+----------------+---------------+----------------+
| ts_1 | data_1.dat | 10240.00000000 | 9926.00000000 | CLUSTER_NODE=2 |
| ts_1 | data_1.dat | 10240.00000000 | 9927.00000000 | CLUSTER_NODE=3 |
+-----------------+------------+----------------+---------------+----------------+
2 rows in set (0.00 sec)
他表的语句为：
| Billinfo | CREATE TABLE `Billinfo` (
`bill_id` int(11) NOT NULL AUTO_INCREMENT,
`ter_id` int(11) DEFAULT NULL,
`tax_reg_id` int(11) DEFAULT NULL,
`payer_id` int(11) DEFAULT NULL,
`tem_id` int(11) DEFAULT NULL,
`tran_serial_num` int(11) DEFAULT NULL,
`date_issued` varchar(56) DEFAULT NULL,
`time_issued` varchar(56) DEFAULT NULL,
`total_in_figures` float DEFAULT NULL,
`discount_amount` float DEFAULT NULL,
`amount_receivable` float DEFAULT NULL,
`payment_type` varchar(56) DEFAULT NULL,
`cashier_num` int(11) DEFAULT NULL,
PRIMARY KEY (`bill_id`),
KEY `Billinfo_id` (`bill_id`)
) ENGINE=ndbcluster AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 |
不知道是哪出问题了，请高手指点
网上说是data memory和index memory 设置过底导致的，我把config.ini文件里data memory=4096M index memory=512M 重启mysql-cluster的五个节点后发现不启作用，应该是设置没有调整过来。请教这两个参数要如何弄才会调整生效？