ClickHouse 之 Server Settings

vim etc/clickhouse-server/config.xml
    
    <users_config>users.xmlusers_config>

<logger>
    <level>tracelevel>      --日志记录级别。可接受的值：trace, debug, information, warning, error
    <log>/var/log/clickhouse-server/clickhouse-server.loglog>                   --日志文件，根据级别包含所有条目
    <errorlog>/var/log/clickhouse-server/clickhouse-server.err.logerrorlog>     -- 错误日志文件
    <size>1000Msize>       -- 文件的大小。适用于loganderrorlog，文件达到大小后，ClickHouse将对其进行存档并重命名，并在其位置创建一个新的日志文件
    <count>10count>        --  ClickHouse存储的已归档日志文件的数量
logger>

<logger>
    <use_syslog>1use_syslog>  -- 写入系统日志
    <syslog>
        <address>syslog.remote:10514address> -- syslogd的主机[：port]。如果省略，则使用本地守护程序
        <hostname>myhost.localhostname>      -- 可选，从中发送日志的主机的名称。
        <facility>LOG_LOCAL6facility> -- syslog关键字，其大写字母带有“ LOG_”前缀：（LOG_USER，LOG_DAEMON，LOG_LOCAL3，依此类推）
        <format>syslogformat>         -- 格式。可能的值：bsd和syslog
    syslog>
logger>

<http_port>8123http_port>

<https_port>8443https_port>
    <openSSL>
        <server> 
            <certificateFile>/etc/clickhouse-server/server.crtcertificateFile>
            <privateKeyFile>/etc/clickhouse-server/server.keyprivateKeyFile>           
            <dhParamsFile>/etc/clickhouse-server/dhparam.pemdhParamsFile>
            <verificationMode>noneverificationMode>
            <loadDefaultCAFile>trueloadDefaultCAFile>
            <cacheSessions>truecacheSessions>
            <disableProtocols>sslv2,sslv3disableProtocols>
            <preferServerCiphers>truepreferServerCiphers>
        server>
        <client> 
            <loadDefaultCAFile>trueloadDefaultCAFile>
            <cacheSessions>truecacheSessions>
            <disableProtocols>sslv2,sslv3disableProtocols>
            <preferServerCiphers>truepreferServerCiphers>
            <invalidCertificateHandler>
                <name>RejectCertificateHandlername>
            invalidCertificateHandler>
        client>
    openSSL>

<tcp_port>9000tcp_port>

<tcp_port_secure> 9440 tcp_port_secure> 

<mysql_port>9004mysql_port>

<interserver_http_port>9009interserver_http_port>

<interserver_http_host>example.yandex.ruinterserver_http_host>

<interserver_http_credentials>
    <user>adminuser>
    <password>222password>
interserver_http_credentials>

<listen_host> :: 1 listen_host>
<listen_host> 127.0.0.1 listen_host>

<max_connections>4096max_connections>

<keep_alive_timeout>3keep_alive_timeout>

<max_concurrent_queries>100max_concurrent_queries>

<max_server_memory_usage>0max_server_memory_usage>

<max_thread_pool_size>10000max_thread_pool_size>

<max_server_memory_usage_to_ram_ratio>0.9max_server_memory_usage_to_ram_ratio>

<max_open_files> 262144 max_open_files>

<uncompressed_cache_size>8589934592uncompressed_cache_size>

<mark_cache_size>5368709120mark_cache_size> 

    
   <path>/var/lib/clickhouse/path>

/var/lib/clickhouse/user_files/user_files_path>

     
<include_from>/etc/metrica.xmlinclude_from>

<graphite>
    <host>localhosthost>   -- Graphite服务器
    <port>42000port>       -- Graphite服务器上的端口
    <timeout>0.1timeout>   -- 发送超时时间，以秒为单位
    <interval>60interval>  -- 发送间隔，以秒为单位
    <root_path>one_minroot_path> -- 密钥的前缀
    <metrics>truemetrics>        -- 从system.metrics表发送数据
    <events>trueevents>          -- 从system.events表发送在该时间段内累积的增量数据
    <events_cumulative>falseevents_cumulative>       -- 从system.events表发送累积数据
    <asynchronous_metrics>trueasynchronous_metrics>  -- 从system.asynchronous_metrics表发送数据
graphite>

set log_queries=1;
Ok.
0 rows in set. Elapsed: 0.001 sec.

select *  from system.settings where name ='log_queries'\G

Row 1:
──────
name:        log_queries
value:       1
changed:     1
description: Log requests and write the log to the system table.
min:         ᴺᵁᴸᴸ
max:         ᴺᵁᴸᴸ
readonly:    0
type:        Bool

1 rows in set. Elapsed: 0.002 sec.