This topic describes the updates and features of PolarDB for MySQL 8.0.1.

8.0.1.1.25

Feature Description Release date
Fixed issue The issues of incorrect results for using index for group by is fixed. 2022-04-12

8.0.1.1.24

Feature Description Release date
Fixed issue
  • The following issue is fixed: threadpool_high_priority_users is not properly parsed when the database starts.
  • The following issue is fixed: Dynamic modification of threadpool_high_priority_users may affect other parameters.
  • The following issue is fixed: Read-only nodes of Archive Database Cluster Edition occasionally crash when redo logs are replayed.
2022-03-11

8.0.1.1.23

Feature Description Release date
New feature and performance optimization
  • Strict consistency cluster is supported on the read-only node.
  • PrepareStatement is suported in the statement outline feature.
  • The hot standby node feature is provided to further optimize high availability efficiency.
2022-01-20
Fixed issue
  • The following issue is fixed: The fast query cache feature blocks the synchronization of redo logs when the read-only node obtains the metadata lock (MDL).
  • The SELECT FOR UPDATE/SHARE WAIT N statement is supported. N specifies the number of seconds during which a row remains locked. The timeout applies only to locking a single row. To lock multiple rows for a query, the system detects the timeout only based on a single row instead of multiple rows. If the lockout time exceeds the specified N value, the system returns a similar lockout timeout error: Lock wait timeout exceeded; try restarting transaction.

8.0.1.1.22

Feature Description Release date
Fixed issue
  • The estimation for the parallelism degree of parallel execution plans is more accurate when the indexes of partitioned tables are the same.
  • The following issue is fixed: The optimizer takes a long time period to estimate the costs of statistics in some scenarios.
  • The following issue is fixed: The optimizer fails to choose a better path to the range of an index for some GROUP BY statements.
  • The following issue is fixed: After a read-only node is promoted to a primary node by using a High Availability (HA) architecture, redo log files fail to be created.
2021-12-22

8.0.1.1.21

Feature Description Release date
Fixed issue
  • The following issue is fixed: When a large value is specified for group_concat_max_len, an arithmetic overflow occurs, which causes an incorrect result of the GROUP_CONCAT function.
  • The following issue is fixed: Data errors occur on read-only nodes in a zone after the nodes recover from a failure.
  • The following issue is fixed: Data exceptions occur after a read-only node in an availability zone is promoted to the primary node.
  • The following issue is fixed: After the filter conditions are specified for multi-column indexes, the optimizer fails to filter the columns and can only filter single-column indexes.
2021-11-26

8.0.1.1.19

Feature Description Release date
New feature and performance optimization
  • New concurrency control rules are added for data definition language (DDL) operations.
  • The restrict_on_limit_without_order parameter can be used to specify whether parallel queries are allowed for statements that contain the LIMIT clause and does not contain the ORDER BY clause.
2021-09-18
Fixed issue
  • The following issue is fixed: When you select the index to perform GROUP BY operations on columns in scenarios where implicit GROUP BY sorting is used in parallel queries, the results of concurrent execution are not sorted.
  • The following issue is fixed: When the thread pool is used, the transaction ID field in audit logs is always 0.

8.0.1.1.18

Feature Description Release date
New feature and performance optimization Transaction resumable upload is supported for the database kernel. Uncommitted transactions can be read by read-only nodes for the database kernel. 2021-08-14
Fixed issue master_key_id_mutex is optimized so that DDL operations can be executed in parallel.

8.0.1.1.17

Feature Description Release date
New feature and performance optimization
  • The polar_replica_work_on_nonblock_mdl_mode parameter is added. If this parameter is set to on, the uncommitted transactions that use the READ UNCOMMITTED or READ COMMITTED isolation level on read-only nodes no longer block DDL operations on the primary node. In addition, atomicity, consistency, isolation, and durability (ACID) is no longer ensured for the operations of creating tables on the read-only nodes.
  • The mechanism of maintaining statistical information is optimized for scenarios in which a large number of tables need to be used, such as scenarios in which software-as-a-service (SaaS) services are required. This way, the performance of querying table schema information by executing the DESC TABLE statement in high concurrency scenarios is significantly improved. The read and write performance in high concurrency scenarios is also significantly improved.
2021-07-23
Fixed issue
  • The following issue is fixed: A read-only node stops responding due to m_recv_bits.is_set(fold) when physical replication is being performed on the node in high concurrency scenarios.
  • The following issue is fixed: A read-only node fails to respond when the node replays logs in high concurrency scenarios.

8.0.1.1.16

Feature Description Release date
Fixed issue When requests are in the Waiting for acl cache lock state, the information about the request threads and the first thread that holds the lock can be printed to the master error logs. This helps diagnose issues. 2021-06-24

8.0.1.1.15

Feature Description Release date
New features and optimized features
  • The Transparent Data Encryption (TDE) feature can be used to automatically encrypt data in tables that are newly created in clusters of the ApsaraDB PolarDB for MySQL.
  • MySQL data tables support the utf8mb4_0900_bin character set.
2021-05-25
Fixed issue
  • The following issue is fixed: A database fails to respond due to an excessive number of log records that are generated after you use the Instant ADD COLUMN feature and then roll back an update operation.
  • The following issue is fixed: Errors occur when DDL statements are executed to forcibly change the storage engine of the mysql.slow_log and mysql.general_log tables to InnoDB.
  • The following issue is fixed: Inaccurate metadata about the REGEXP function causes invalid result sets.
  • The following issue is fixed: The database crashes when you roll back an update operation on a virtual column.
  • The policy that specifies whether the checkpoint process is immediately triggered after read-only nodes establish a replication relationship with the primary node can be adjusted. If the difference between the log sequence number (LSN) of two consecutive log records is less than the specified threshold, you can configure a policy to prevent the checkpoint process from being triggered.

8.0.1.1.14

Feature Description Release date
New feature and performance optimization
  • The mechanism of maintaining internal index information is optimized for scenarios in which a large number of tables need to be used, such as scenarios in which SaaS services are required. This way, read-only nodes can be started within a shorter time period.
  • Synchronization links in global database networks (GDNs) are optimized. This reduces the amount of CPU resources consumed by synchronization threads. This also improves the speed of synchronizing redo logs between clusters that have less than 8 CPU cores.
  • The AutoDop policy specified by the parameter that controls the degree of parallelism (DOP) is optimized. This optimization eliminates the impact on the use of parallel hints and the force_parallel_mode parameter.
2021-04-23
Fixed issue
  • The following issue is fixed: When the scope of a range query is large, invalid indexes are used due to the inaccurate statistics returned by the records_in_range method.
  • The following issue is fixed: Read-only nodes do not respond due to excessively small buffer pools when a point-in-time restore is used to restore full data.
  • The following issue is fixed: The memory usage of metadata caches in X-Engine is excessively high.
  • Two ACL DDL issues of MySQL are fixed to prevent cluster unavailability caused by deadlocks that occur due to ACL DDL operations.
  • The following issue is fixed: Invalid result sets are returned when aggregate functions are used in parallel queries that include the SQL_BUFFER_RESULT keyword and exclude GROUP BY.

8.0.1.1.13.2

Feature Description Release date
Fixed issue The following issue is fixed: The encryption information in tables that are encrypted by TDE may be lost during a failover. This results in decryption errors. 2021-04-19

8.0.1.1.13.1

Feature Description Release date
Fixed issue The following issue is fixed: For parallel queries, longer response time is required because constant filter conditions specified in Block Nested-Loop (BNL) join algorithms are not pushed down to each queried table. 2021-04-08

8.0.1.1.13

Feature Description Release date
New feature and performance optimization
  • The polar_use_statement_mdl_on_replica parameter is available for read-only nodes. When this parameter is set to on, this setting prevents transactions that use the RC isolation level on read-only nodes from blocking DDL operations on the primary node. When a read transaction on a read-only node is concurrent with a DDL operation on the primary node, the statements in the read transaction read different data sets from tables. For example, if two statements are included in a read transaction on a read-only node and an ADD COLUMN operation is performed on the primary node during the execution interval of the two statements, the second statement on the read-only node reads data from more columns than the first statement.
  • Unnecessary equality conditions for indexes in queries are removed. This helps push down the LIMIT and OFFSET clauses when the ORDER BY LIMIT clause is used.
  • The dbms_stats.gather_stats(timeout, workers) command is added. You can run this command to update outdated histograms. You can also use scheduled events to update outdated histograms.
  • The data of the log_version, log_id, origin_start_time, and rds_ext fields can be queried from the mysql.slow_log table.
2021-03-30
Fixed issue
  • The following issue is fixed: Queries cannot be canceled when you execute CHECK TABLE, COUNT(*), or DDL statements on X-Engine tables in an archive database.
  • KICKOUT is used as a non-reserved keyword.
  • The following issue is fixed: In some scenarios, parallel queries are not performed as expected when the evaluated number of rows to be scanned in the execution plan is less than the actual number of scanned rows.

8.0.1.1.12.2

Feature Description Release date
Fixed issue
  • The following issue is fixed: A cluster becomes unavailable when you create or delete temporary tables during the storage process. This issue occurs when the session_track_temporary_tables system variable is enabled.
  • The patch for MySQL 8.0.14 is provided to fix the following issue: CREATE USER statements cannot be executed as expected because the metadata locks (MDLs) of system tables in the corresponding MySQL database cannot be acquired.
2021-03-12

8.0.1.1.12.1

Feature Description Release date
New feature and performance optimization The write performance of X-Engine in PolarDB Archive Database is optimized when you continuously import data to multiple tables. 2021-03-02
Fixed issue The following issue is fixed: In parallel queries, the MDL state for the leader thread may be different from that for the worker thread, because the leader thread does not own mutual exclusion locks (mutexes).

8.0.1.1.12

Feature Description Release date
New feature and performance optimization
  • The auto_dop_low_degree_cost parameter can be used to specify the DOP policy. This parameter is used to determine how to automatically specify the DOP for parallel queries. For more information, see DOP policy.
  • The restore_table command is supported. You can run the command to restore tables from the recycle bin. For more information, see Recycle bin.
  • Binary logs can be retrieved from read-only nodes. For more information, see Remotely obtain and parse binary log records from a cluster of the PolarDB for MySQL.
  • The key information such as in_memory can be printed in opt trace. This allows you to locate the causes of exceptions on an execution plan.
2021-02-20
Fixed issue
  • The Port Percona patch is provided to reduce the time that is required to detect conflicts of ACL cache MDLs in high concurrency scenarios.
  • The preferred_ordering_index parameter is added for the optimizer_switch system variable to fix the issue that the optimal plan is not used due to ordered indexes in some scenarios. For example, this issue occurs when you use LIMIT clauses in ORDER BY or GROUP BY queries.
  • The following issue is fixed: The SHOW PROCESSLIST statement in some scenarios returns an invalid result.
  • The following issue is fixed: For PolarDB for MySQL 8.0.1.1.10 or earlier, after you upgrade the minor version, results cannot be quickly returned when you query system tables. This is because the definition of the information_schame.KEY_COLUMN_USAGE system table is not updated.

8.0.1.1.11

Feature Description Release date
New feature and performance optimization
  • The parallel_degree_policy parameter can be used to specify the DOP policy for parallel queries. For more information, see DOP policy.
  • The SET GLOBAL statement can be executed to specify the max_digest_length parameter. This parameter is used to limit the length of recognizable statements.
    Note After you change the value of max_digest_length, the client must reconnect to the cluster. Otherwise, the new value does not take effect.
  • The default value of the innodb_adaptive_hash_index parameter is changed from ON to OFF.
2021-01-29
Fixed issue
  • The following issue is fixed: The permissions on the primary node are different from the permissions on read-only nodes.
  • The following issue is fixed: Read-only nodes cannot connect to the primary node after a failover.
  • The following issue is fixed: The processing logic of the SPM is wrong when a specific execution plan becomes invalid.

8.0.1.1.10

Feature Description Release date
New feature and performance optimization
  • Implicit GROUP BY sorting is supported. You can use this feature in the same manner in which you use it in PolarDB for MySQL 5.7.
  • Parallel queries can be disabled if a BLOB field exists.
  • The cache information about statement concurrency control can be automatically updated on read-only nodes.
  • The hot row optimization feature is supported. For more information, see Hot row optimization.
  • The DDL physical replication optimization feature is supported. For more information, see DDL physical replication optimization.
  • The Async Metadata Lock Replication feature is supported. For more information, see Async Metadata Lock Replication.
  • Quick reverse traversal is supported when computations are pushed down to InnoDB.
  • The file system is optimized to speed up the process of opening multiple tables at the same time.
  • In multi-table scenarios, the time consumed by a failover is reduced and the recovery of the new primary node is accelerated.
2021-01-12
Fixed issue
  • The following issue is fixed: The system tables are lost when a read-only node is promoted to the primary node.
  • The following issue is fixed: The estimated number of scanned rows is excessively large when range queries are used after the parallel query feature is enabled.
  • The following issue is fixed: The results of aggregate queries are of the integral data type if the field data type is BIT.
  • The following issue is fixed: SELECT DISTINCT queries return invalid results after enumerated fields are used.
  • The following issue is fixed: An exception occurs in the results of parallel queries that use the EXISTS condition.
  • The following issue is fixed: Read-only nodes fail to restart in some scenarios.
  • The following issue is fixed: An exception occurs in table information in the data dictionary when a read-only node executes DDL statements. This is because the table for which DDL statements are being executed is re-opened when a foreign key association table is opened.
  • The following issue is fixed: When you query data by using full-text indexes, failures occur due to the improper setting of a node restart flag after a failover.
  • The following issue is fixed: The log application threads on read-only nodes are blocked due to an MDL.
  • The following issue is fixed: The new primary node becomes unavailable after a failover because the released memory is reused.
  • The following issue is fixed: All nodes become unavailable due to polar.info data errors.
  • The following issue is fixed: Auto-increment column exceptions occur in partitioned tables.
  • The following issue is fixed: A data error occurs when redo logs on the primary node are overwritten.
  • The following issue is fixed: The primary node becomes unavailable when it is waiting for an MDL.
  • The issues related to the TDE feature are fixed.
  • The following issue is fixed: A cluster becomes unavailable when you execute the LOCK TABLE statement and enable the recycle bin feature.
  • The following issue is fixed: A deadlock occurs when DDL statements are executed on the primary node.
  • The following issue is fixed: The thread pool and the connection control cannot take effect at the same time.

8.0.1.1.9

Feature Description Release date
New feature and performance optimization The SPM and PLAN keywords are removed. This way, you can manage the tables whose names contain these two words. 2020-12-18

8.0.1.1.8

Feature Description Release date
New feature and performance optimization
  • The multi-plan mode is supported in the execution plan manager.
  • The rds_ap_threshold system variable is added to block the requests that cause the system to scan an excessive number of records. These requests are evaluated by the optimizer.
  • The efficiency of writing dirty pages to disks on the primary node is improved.
  • A multi-shard writing mechanism for redo logs is supported.
2020-12-09
Fixed issue
  • The following issue is fixed: A null pointer of the MDL key occurs in parallel queries.
  • The following issue is fixed: A query fails when you create a parallel thread cache.
  • The following issue is fixed: An error is returned when multi-range read (MRR) is used in parallel queries.

8.0.1.1.7

Feature Description Release date
New feature and performance optimization
  • The efficiency of scanning driven tables in parallel is improved in scenarios such as JOIN queries.
  • When the binary logging feature is disabled, remaining binary logs can be cleared.
  • Interrupted physical replications of read-only nodes can be automatically detected and then resumed. This way, physical replications can be resumed at the earliest opportunity when they are interrupted.
  • The efficiency of failovers between the primary node and read-only nodes is improved.
  • Quick startup is supported for clusters that contain a large number of tables. This way, data files can be rapidly scanned.
2020-11-16
Fixed issue
  • The following issue is fixed: A cluster breakdown may occur when you obtain the type of trx->wait_lock.
  • The following issue is fixed: The number of AIO threads reaches the upper limit when a multi-queue simulated AIO is enabled.
  • The following issue is fixed: A query cannot be canceled if a query initialization failure occurs when you query indexes.
  • The following issue is fixed: The Next Page of the current cursor points to a page that does not exist when a read-only node is performing a split-merge operation (SMO).
  • The following issue is fixed: Read-only nodes read logs that are overwritten by the primary node.
  • The following issue is fixed: The system fails to clear redo logs because the timestamp intervals of redo logs are excessively large.
  • The following issue is fixed: The table cache information in the related cache is not cleared after MDLs are released.

8.0.1.1.6

Feature Description Release date
New feature and performance optimization
  • The compatibility between the SQL plan manager (SPM) and parallel queries is improved.
  • The efficiency of merging and sorting parallel queries is improved.
  • DELETE operations can be pushed down to InnoDB.
  • The CTS feature of PolarDB is supported.
2020-09-21
Fixed issue
  • The following issue is fixed: The description of pq_optimize_switch is incorrect.
  • The following issue is fixed: Subqueries cannot be stably executed.

8.0.1.1.5

Feature Description Release date
New feature and performance optimization
  • A feature is added to decide whether the primary node must apply the checkpoint policy immediately when it establishes a replication relationship with read-only nodes.
  • Range queries are supported and can be pushed down.
  • The pfs_remount feature is supported for Polar File System (PFS). This feature fixes the issue that files in PFS fail to be mounted when the files are open.
  • The performance bottlenecks caused by forcible pauses of parse threads on read-only nodes are removed. The efficiency of data synchronization between the primary node and read-only nodes during physical replication is improved.
  • The performance of Early Lock Release (ELR) is improved in multi-connection scenarios. The cluster performance in multi-connection scenarios is improved by nine times.
2020-08-19
Fixed issue
  • The following issue is fixed: Read-only nodes become unavailable after these nodes fail to connect to the primary node.
  • The following issue is fixed: After a full-text index is used and DDL statements are executed, a read-only node becomes unavailable after a failover.
  • The following issue is fixed: Binary logs cannot be purged after the UNDO TRUNCATE command is run.
  • The following issue is fixed: Statistics are inconsistent between the primary node and read-only nodes.

8.0.1.1.4

Feature Description Release date
New feature and performance optimization
  • DDL statements can be executed in parallel. This improves the efficiency of executing DDL statements.
  • The length of each queue for the simulated asynchronous I/O (AIO) can be dynamically adjusted.
  • Data in a full-text search (FTS) index cache can be synchronized between the primary node and read-only nodes. This ensures cache coherence.
  • The subqueries that include aggregate functions are supported in WHERE clauses. In addition, if the subqueries support index-based scans, these subqueries can be executed in parallel.
  • The lock mode can be checked for temporary tables and standard tables.
2020-07-04
Fixed issue
  • The following issue is fixed: Clusters become unavailable because some DDL statements are being replicated when the primary node serves as a read-only node.
  • The following issue is fixed: The performance is compromised because thread pools are enabled.
  • The following issue is fixed: Deadlocks occur because binary logs are purged.
  • Several issues that are related to a memory leak are fixed.
  • Several issues that occur in high availability scenarios are fixed.

8.0.1.1.3

Feature Description Release date
New feature and performance optimization
  • Security is enhanced. For example, password management is improved.
  • The performance of parallel queries is improved in the following scenarios:
    • The GROUP BY, UNION, and SELECT COUNT(*) FROM <Table> queries are performed.
    • Shared InnoDB temporary tables are used for execution plans in parallel subqueries.
    • Views, derived tables, and temporary tables are used in execution plans.
    • Temporary tables can be used for parallel queries. When you use temporary tables for parallel queries, take note of the following limits:
      • If you do not specify conditions in the SELECT COUNT(*) statement to query data in temporary tables, parallel queries are not supported.
      • Parallel queries are not supported for temporary tables that use the Memory storage engine.
  • A new version of the audit log format is supported. In this format, information about virtual IP addresses (VIPs) is added.
  • The rate of idle space to total space on index pages can be managed. This reduces latch contention and the probability of performing structure modification operations (SMOs), and improves write performance.
  • The simulated AIO among multiple queues is supported. This improves dirty page flushing and write performance.
  • Buffer pool pages can be excluded from core files. This reduces the sizes of the core files and minimizes the impact on online services.
2020-05-29
Fixed issue
  • The following issue is fixed: If the upper limit of memory in TempTable is reached, the TempTable storage engine reports an out of memory (OOM) error. In this case, the data is not moved from memory to disks.
  • The following issue is fixed: Clusters become unavailable when the sort buffer size is set to an excessively small value and ORDER BY is used in InnoDB FTS.
  • The following issue is fixed: If a temporary table contains duplicate column names, the requested fields fail to be returned.
  • The following issue is fixed: In parallel queries, when the MAX or MIN function is used together with GROUP BY and loose index scans are used, the statements are still being executed after the queries are killed.
  • Several issues that are related to failovers are fixed.
  • Several issues that are related to parallel queries are fixed.
  • The following issue is fixed: When you execute the SHOW BINARY LOGS statement, transactions may not be committed.

8.0.1.1.2

Feature Description Release date
New feature and performance optimization
  • The sorting method is optimized. Column values are first sorted based on string prefixes, and then based on entire strings. To be more specific, if the string prefixes of the column values are the same, the column values are sorted based on the entire strings. When columns of the CHAR and VARCHAR data types are sorted, you can specify the maximum length of different strings in the prefix to accelerate the comparison process. This reduces the sorting time.
  • Parallel queries are supported in the following scenarios:
    • Parallel queries are supported for cost models of range scans.
    • Parallel queries are supported for temporary tables.
    • Parallel queries can be performed based on the semi-join materialization strategies: lookup and scan.
  • Three types of session state trackers are added. The PolarDB intelligent proxy can use these session state trackers to help apply the persistent connection feature. After the trackers are enabled, you can track the changes of user variables in sessions, CREATE and DELETE operations on temporary tables, and PREPARE and DEALLOCATION operations in SQL statements.
  • The performance of dropping an adaptive hash index (AHI) is optimized when DDL statements are executed. This reduces the impact of DDL statements on cluster performance.
  • The recycle bin feature is added to prevent data loss that is caused by unintended deletion operations.
  • The performance of truncating temporary tablespaces in large buffer pools is improved. This reduces the impact of the operations that are related to temporary tables on cluster performance.
2020-04-09
Fixed issue
  • The following issue is fixed: If aggregate functions are nested in the IF function, an error occurs when the ROLLUP function is executed.
  • The issues that occur when the values of the BLOB data type are sorted are fixed.
  • The issue that occurs when the SQL PREPARE statement includes aggregate functions in parallel queries is fixed.
  • Several issues that are related to parallel queries are fixed.
  • The following issue is fixed: Excessive redo logs may be cleared.
  • The issues that are related to the redo logs of read-only nodes are fixed.

8.0.1.1.1

Feature Description Release date
New feature and performance optimization
  • Parallel queries are supported when subqueries contain the ROLLUP function.
  • The statement concurrency control feature is supported.
  • The POLARDB_INDEX hint is added.
  • The replication delay between the primary node and read-only nodes is reduced.
  • The thread pool feature is supported. For more information, see Thread pool.
  • The keyring_rds plug-in for TDE is supported.
  • GDNs are supported. For more information, see Create and release a GDN.
  • The lock-free transaction system is optimized and the read and write performance is improved.
2020-03-28
Fixed issue
  • Several issues that are related to parallel queries are fixed.
  • The following issue is fixed: A value of 0 may be returned for the statistics in online DDL operations.
  • The file system in user mode is optimized to accelerate cluster startup.
  • The following issue is fixed: Clusters may become unavailable when innodb_flush_method is set to all_o_direct.
  • The following issue is fixed: Clusters may become unavailable if you release a lock after a transaction is committed.
  • The following issue is fixed: User requests may be blocked when slow query logs are truncated.
  • The following issue is fixed: Clusters may become unavailable due to the compressed pages on read-only nodes.
  • The following issue is fixed: Replication connections may be killed in thread pools by mistake.

8.0.1.1.0

Feature Description Release date
New feature and performance optimization
  • The parallel query feature is improved, and the parallel computing of the ROLLUP function that is used for enterprise-level analysis is supported.
  • The capabilities of the optimizer cost model are improved. You can specify filters to decrease selectivity. The cost model is supported for parallel queries. The optimizer checks whether a parallel or serial execution plan is used for the executed SQL statements based on the selectivity.
  • Parallel threads can be allocated based on the first in, first out (FIFO) mode and managed in a unified manner. This ensures that system resources are not exhausted by a large number of parallel queries.
2020-02-05
Fixed issue
  • Issues that are related to memory in parallel queries are fixed.
  • Issues that are related to instability in parallel queries are fixed.

8.0.1.0.6

Feature Description Release date
Fixed issue
  • The following issue is fixed: The binary log index file is not closed after the primary node serves as a read-only node.
  • The following issue is fixed: Clusters become unavailable when read-only nodes access undo log pages that are purged.
  • The following issue is fixed: Background threads access tablespace pages that do not exist when a read-only node is promoted to the primary node during a failover.
  • The following issue is fixed: After clusters are shut down, log threads exit but redo logs are still being written. As a result, the clusters become unavailable.
2020-01-01

8.0.1.0.5

Feature Description Release date
New feature and performance optimization
  • The optimizer trace feature allows you to trace information about parallel queries. For example, you can use the optimizer trace tool to analyze the reason why a parallel query is used or not used.
  • Hints are added for parallel queries. You can add hints to SQL statements to explicitly enable parallelism and specify the degree of parallelism.
  • Parallel scans are supported if you execute the INSERT INTO SELECT statement when the isolation level is READ COMMITTED. You can execute the INSERT INTO SELECT statement to query data and insert the result into another table.
2019-12-03
Fixed issue
  • Several issues that are related to parallel queries are fixed.
  • The following issue is fixed: After a read-only node is promoted to the primary node during a failover, the new primary node becomes unavailable.
  • The following issue is fixed: Errors are reported due to the execution of some DDL statements when a failover occurs.
  • The following issue is fixed: The error message "too many connection error" is reported when the upper limit of connections that are supported by locks is reached.