ANALYZE TABLE xxx RELOAD syntax. After one compute node updates the statistics, it notifies other compute nodes to perform RELOAD, avoiding redundant statistics updates across multiple compute nodes.tdstore_auto_stat_min_interval_microsecond, tdstore_auto_stat_min_update_num, and tdstore_auto_stat_when_update_rate to control the frequency of automatic statistics updates.parallel_query_switch='join=off' to disable JOIN support.SELECT COUNT(*) queries without GROUP BY can choose to take the parallel query path, can use parallel hints and parallel variable settings; use SET SESSION tdsql_parallel_optim = OFF (default is ON) to enable this feature.SELECT b FROM t1 FORCE INDEX idxb AS OF TIMESTAMP '2023-12-10 12:00:00';.CREATE TABLE to create user tables in the mysql database. Attempting this operation will result in the error ERROR 8565 (HY000): Can't create/move table in/to the db. DB(mysql) and table(mysql.t1) are in different dataspaces.SET tdsql_parallel_worker_scheduling = 'auto'. After EXPLAIN ANALYZE is executed, check information_schema.optimizer_trace to verify task status.raft_node_enable_flow_control and raft_node_flow_control_threshold, to implement flow control.raft_node_enable_flow_control is set to true, if the memory occupied by Raft Cache on the Leader exceeds raft_node_flow_control_threshold, the rate of generating Raft Log will be reduced.raft_node_enable_flow_control is set to true, if the memory occupied by Raft Cache on the Follower may exceed raft_node_flow_control_threshold, then reduce the synchronization speed of Raft Log.raft_log_enable_compression, raft_log_compress_type, and raft_per_log_min_compress_threshold, to control compression. Among these, raft_log_enable_compression indicates whether to enable compression, raft_log_compress_type specifies the type of compression algorithm to select, with 1 representing Snappy and 2 representing LZ4, and raft_per_log_min_compress_threshold indicates the minimum length for a Raft Log to participate in compression.information_schema.partitions view executed slowly with high memory consumption. Optimized the original view definition by addressing the performance degradation and excessive temporary table overhead caused by UNION operations.CREATE TABLE recovery exceptions caused failure to clean up residual data objects and their corresponding Regions and Replication Groups.Change Type | Parameter Name | Description |
Addition | In bulkload data import scenarios, typically, the data volume of each bulkload transaction is relatively large, ranging from several hundred MB to GB. Therefore, the data within a bulkload transaction is saved in temporary data files before being committed, which reduces and controls memory overhead. For unordered data (such as secondary index data) in a bulkload transaction, external merge sorting is performed during the transaction commit phase. tdstore_bulk_load_merge_chunk_size is used to set the memory size in bytes for caching data before external merging and sorting of unordered data in a bulkload transaction. | |
Addition | In bulkload data import scenarios, typically, the data volume of each bulkload transaction is relatively large, ranging from several hundred MB to GB. Therefore, the data within a bulkload transaction is saved in temporary data files before being committed, which reduces and controls memory overhead. For unordered data (such as secondary index data) in a bulkload transaction, external merge sorting is performed during the transaction commit phase. tdstore_bulk_load_total_merge_buffer_size is used to set the total size of the memory buffer in bytes for external merge sorting in a bulkload transaction. | |
Addition | In bulkload data import scenarios, typically, the data volume of each bulkload transaction is relatively large, ranging from several hundred MB to GB. Therefore, the data within a bulkload transaction is saved in temporary data files before being committed, which reduces and controls memory overhead. For unordered data (such as secondary index data) in a bulkload transaction, external merge sorting is performed during the transaction commit phase. tdstore_bulk_load_total_merge_buffer_size is used to set the total size of the memory buffer in bytes for external merge sorting in a bulkload transaction. |
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback