Settings profiles

    Example:

    Settings profiles are declared in the user config file. This is usually users.xml.

    1. <!-- Settings profiles -->
    2. <profiles>
    3.     <!-- Default settings -->
    4.     <default>
    5.         <!-- The maximum number of threads when running a single query. -->
    6.         <max_threads>8</max_threads>
    7.     </default>
    9.     <!-- Settings for quries from the user interface -->
    10.     <web>
    11.         <max_rows_to_read>1000000000</max_rows_to_read>
    12.         <max_bytes_to_read>100000000000</max_bytes_to_read>
    14.         <group_by_overflow_mode>any</group_by_overflow_mode>
    16.         <max_rows_to_sort>1000000</max_rows_to_sort>
    17.         <max_bytes_to_sort>1000000000</max_bytes_to_sort>
    19.         <max_result_rows>100000</max_result_rows>
    20.         <max_result_bytes>100000000</max_result_bytes>
    21.         <result_overflow_mode>break</result_overflow_mode>
    23.         <max_execution_time>600</max_execution_time>
    24.         <min_execution_speed>1000000</min_execution_speed>
    26.         <max_columns_to_read>25</max_columns_to_read>
    27.         <max_temporary_columns>100</max_temporary_columns>
    30.         <max_subquery_depth>2</max_subquery_depth>
    31.         <max_pipeline_depth>25</max_pipeline_depth>
    32.         <max_ast_depth>50</max_ast_depth>
    33.         <max_ast_elements>100</max_ast_elements>
    35.         <readonly>1</readonly>
    36.     </web>

    The example specifies two profiles: default and web. The default profile has a special purpose: it must always be present and is applied when starting the server. In other words, the default profile contains default settings. The web profile is a regular profile that can be set using the SET query or using a URL parameter in an HTTP query.