ALTER TABLE user_hot_click_list_weekly SET TIFLASH 1;语法错误?

CREATE DATABASE feature;
use feature;

CREATE TABLE feature.user_hot_click_list_weekly (
gid BIGINT NOT NULL,
feat_val TEXT NOT NULL,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
UNIQUE KEY (gid)
)
;

MySQL [feature]> ALTER TABLE feature.user_hot_click_list_weekly SET TIFLASH 1;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 60 near “1”

版本:
MySQL [feature]> select @@version;
±-------------------+
| @@version |
±-------------------+
| 5.7.25-TiDB-v4.0.0 |
±-------------------+

1 个赞

你好,

请认真核对语法。

ALTER TABLE table_name SET TIFLASH REPLICA count

例子:

ALTER TABLE tpch50.lineitem SET TIFLASH REPLICA 2

PS:
请认真填写分类和标签,感谢

尴尬,是说我分类还是标签有填错是吗?给个文档指导或本例正确姿势?

其实关于副本数,还有个问题;正式环境至少要3副本,也就是3台来保证高可用是吧?

是的,推荐 3 副本及以上副本数配置,并奇数上涨 5 7 9 ,

此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。