Question about "mutations_sync"

19 views
Skip to first unread message

joan.ba...@gmail.com

unread,
May 7, 2021, 7:46:31 AMMay 7
to ClickHouse
Hello,

We are using ALTER TABLE ... DELETE, and we need this delete to be sync. We tried to add the setting "<mutations_sync>1</mutations_sync>" to the config.xml file, but after doing this CH does not start (ClickHouse server version 21.2.3 revision 54447)

Where should we apply this setting?

Thanks,

Joan.

Denis Zhuravlev

unread,
May 7, 2021, 5:41:47 PMMay 7
to ClickHouse
for query : ALTER TABLE A DELETE where 1 settings mutations_sync=2;

for session : set mutations_sync=2;

for user profile:
cat /etc/clickhouse-server/users.d/dfsdfsdfw.xml
<?xml version="1.0" ?>
<yandex>
    <profiles>
        <default>
            <mutations_sync>2</mutations_sync>
        </default>
    </profiles>
</yandex>
Reply all
Reply to author
Forward
0 new messages