Clickhouse select query without cache

Question

Is there any "without cache" option in clickhouse select query?

I want to check run-time performance of clickhouse without cache.

I expect options like SQL_NO_CACHE in mysql.

SELECT SQL_NO_CACHE * FROM table WHERE search= 'keyword';

Answer 1

The cache reset is done in two steps:

1. reset the OS PageCache

sync; echo 1 > /proc/sys/vm/drop_caches

2. reset mark-cache in CH using DROP MARK CACHE

SYSTEM DROP MARK CACHE