【】mysql cluster性能测试，报错汇总，期待大家提供宝贵的建议！

mchdba

devilkin0312 发表于 2012-7-16 20:56
兄弟，我对不起你，

肿么了？

mchdba

ndb_mgm> Node 4: Data usage increased to 80%(89952 32K pages of total 112000)
Node 4: Data usage increased to 90%(101397 32K pages of total 112000)
Node 4: Data usage decreased to 86%(97094 32K pages of total 112000)
Node 4: Data usage decreased to 76%(85144 32K pages of total 112000)

才插入了20W记录，内存就满了，我的参数：DataMemory=3500M，3G这么快就塞满了啊！

不知道能否在线修改这个参数值呢?
继续做实验：

mysql> insert into ndborder_info_history select * from order_info_history limit 250000,200000;
ERROR 1114 (HY000): The table 'ndborder_info_history' is full
mysql> insert into ndborder_info_history select * from order_info_history limit 50000,50000;  
Query OK, 50000 rows affected (17.90 sec)
Records: 50000  Duplicates: 0  Warnings: 0
mysql> insert into ndborder_info_history select * from order_info_history limit 100000,50000;
Query OK, 50000 rows affected (18.27 sec)
Records: 50000  Duplicates: 0  Warnings: 0
mysql> insert into ndborder_info_history select * from order_info_history limit 150000,50000;
Query OK, 50000 rows affected (18.90 sec)
Records: 50000  Duplicates: 0  Warnings: 0
mysql> insert into ndborder_info_history select * from order_info_history limit 250000,50000;
Query OK, 50000 rows affected (12.53 sec)
Records: 50000  Duplicates: 0  Warnings: 0
mysql>
mysql>
mysql> insert into ndborder_info_history select * from order_info_history limit 300000,100000;
Query OK, 100000 rows affected (23.92 sec)
Records: 100000  Duplicates: 0  Warnings: 0
mysql> insert into ndborder_info_history select * from order_info_history limit 400000,150000;
Query OK, 150000 rows affected (36.09 sec)
Records: 150000  Duplicates: 0  Warnings: 0
mysql>
mysql>
mysql> insert into ndborder_info_history select * from order_info_history limit 550000,180000;
ERROR 1114 (HY000): The table 'ndborder_info_history' is full
mysql> insert into ndborder_info_history select * from order_info_history limit 550000,170000;
Query OK, 170000 rows affected (39.38 sec)
Records: 170000  Duplicates: 0  Warnings: 0
mysql>

从这里可以看出当一次插入180000数据的时候，会报错The table 'ndborder_info_history' is full，只要少于这个数值，就不会报错full。可见这个full的错误不是真的内存不足，而是一次insert的记录太多导致。

kerlion

还怎么测试到这个问题，只有看mysql的官方解释了.你的字段是怎么定义的？？

mchdba

kerlion 发表于 2012-7-17 09:18
还怎么测试到这个问题，只有看mysql的官方解释了.你的字段是怎么定义的？？

sorry，你说的是我的哪一个问题呢？

mchdba

6：
mysql> CREATE DATABASE zhang;
Query OK, 1 row affected, 2 warnings (0.01 sec)

mysql>
mysql>
mysql>
mysql> show warnings;
+---------+------+----------------------------------------------------------------------------------+
| Level   | Code | Message                                                                          |
+---------+------+----------------------------------------------------------------------------------+
| Warning | 1296 | Got error 4009 'Cluster Failure' from NDB. Could not acquire global schema lock  |
| Warning | 1296 | Got error 4009 'Cluster Failure' from Could not log query '%s' on other mysqld's |
+---------+------+----------------------------------------------------------------------------------+
2 rows in set (0.00 sec)



【ok】安全模式启动
/usr/local/mysql/bin/mysqld_safe &

Mr_dream

您好，我问一个问题，我在sql节点创建完表之后 数据为什么在sql节点 而不在ndb节点 是我配置错了？