Question about "mutations_sync"

[joan.ba...@gmail.com]

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]

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>