TDSQL-C for MySQL
- Release Notes and Announcements
- Announcements
- Product Introduction
- Suggestions on Usage Specifications
- Kernel Features
- Kernel Version Release Notes
- Optimized Kernel Version
- Functionality Features
- Performance Features
- Security Features
- Stability Feature
- Analysis Engine Features
- Purchase Guide
- Value-Added Services Billing Overview
- Database Audit
- Audit Rule Template
- Serverless Service
- Serverless Introduction
- Serverless Resource Pack
- Configuration Change
- Operation Guide
- Database Connection
- Configuring Network Address
- Instance Management
- Configuration Adjustment
- Instance Mode Management
- Cluster Management
- Scaling Instance
- Database Proxy
- Database Proxy Kernel Features
- Managing Database Proxy
- Automatic Read/Write Separation
- Connection Pool Feature
- Other Features
- Account Management
- Console Account
- Database Account
- Configuring Custom Password Strength
- Database Management
- Database Management Tool
- Columnar Storage Index (CSI)
- Utilization of Columnar Storage Indexes
- Read-Only Analysis Engine
- Feature Limits and Compatibility
- Description of Functions and Operators
- Read-Only Analysis Engine Management
- Data Loading
- Executing Queries
- Exclusive Features
- Performance Optimization
- Performance White Paper
- Parameter Configuration
- Multi-AZ Deployment
- Backup and Restoration
- Performing Backup
- Managing Backup
- Rollback
- Restoring Data from Logical Backups
- Restoring Data Through the Console
- Restoring Data from Snapshot Backup
- Data Migration
- Parallel Query
- Setting Parallel Query
- Database Security and Encryption
- Access and Authorization
- Security Group Management
- TencentDB Security Group Management
- Monitoring and Alarms
- Monitoring
- Alarms
- Monitoring Metric Alarm
- Practical Tutorial
- Data Rollback
- Database/Table-Level Rollback
- Rolling back Entire Cluster
- White Paper
- Security White Paper
- Performance White Paper
- Troubleshooting
- Connection Issues
- API Documentation
- Making API Requests
- Instance APIs
- Account APIs
- Audit APIs
- Database Proxy APIs
- Backup and Restoration APIs
- Parameter Management APIs
- Performance Analysis APIs
- Serverless APIs
- ResourcePackage APIs
- Other APIs
- FAQs
- Service Agreement
- TDSQL-C Policy
- General References
DocumentationTDSQL-C for MySQLOperation GuideColumnar Storage Index (CSI)Utilization of Columnar Storage IndexesParameter Configuration and Monitoring Metrics
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. |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No