tencent cloud

Feedback

Parameter Configuration and Monitoring Metrics

Last updated: 2024-06-07 14:38:10
    This document describes the parameter configuration and monitoring metrics of Column Store Index (CSI).

    Prerequisites

    The kernel version of TDSQL-C for MySQL 8.0 is 3.1.14 or later.
    Note:
    For read-only instances that meet the version requirements, the CSI feature can be enabled only on those with four or more CPU cores.

    Parameters

    Name
    Type
    Default Value
    Value Range
    Description
    columnstore_buffer_pool_size
    int
    1024
    0, INT_MAX
    Total memory of C-Store (size of the CSI buffer pool), in MB.
    columnstore_scan_pushdown_rows_threshold
    int
    100000
    0, INT_MAX
    If the number of data rows in an index table is less than this threshold, the data of the table will not be accessed through column storage. This parameter is not a global parameter and is effective only for instances with the CSI feature enabled.

    CSI Monitoring Metrics

    Metric Name
    Unit
    Aggregation Method
    Description
    Innodb_csi_select_pushdown
    
    SUM
    Number of executed statements for CSI-based queries.
    Innodb_csi_select_fallback
    
    SUM
    Number of CSI rollback statements.
    innodb_csi_lag_seconds
    Second
    MAX
    Synchronization delay between read-write instances and instances with CSI enabled.
    Innodb_csi_disk_usage
    GB
    MAX
    Storage space used by column store indexes.
    txsql_csi_fail
    
    SUM
    Number of column store indexes failed to be created.
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support