Update rt_mem_limit for cluster tables

General Discussions - English
1

Hi guys. What’s the correct procedure for updating the rt_mem_limit value for a cluster table? I cannot use ALTER TABLE.

mysql> ALTER TABLE contact_shard_0 rt_mem_limit=‘1G’;
ERROR 1064 (42000): table ‘contact_shard_0’ is part of cluster contact_cluster, ALTER is not supported for tables in cluster

Do I have to remove the table from the cluster, update each host with the new rt_mem_limit value, and add it again?

2

Yes, you need to remove it from the cluster, run the ALTER, and then add it back. Once you add it again, it will be sent to the other nodes. For example:

mysql> alter cluster c drop t;
Query OK, 0 rows affected (0.25 sec)

mysql> alter table t rt_mem_limit='8m';
Query OK, 0 rows affected (0.02 sec)

mysql> alter cluster c add t;
Query OK, 0 rows affected (0.37 sec)
1 Like