×
Community Blog Cloud Forward Episode 3: Cloud-Native Database - PolarDB | Parallel Query

Cloud Forward Episode 3: Cloud-Native Database - PolarDB | Parallel Query

To truly resolve the issue of SQL execution time getting slower as data gets bigger, PolarDB for MySQL adopted the feature of Parallel Query at the kernel level.

Why is SQL execution time still getting slower, even after migrating to the cloud?

Hello and welcome to another episode of Cloud Forward.

Today, we'll look at how we can improve SQL performance.

MySQL, as an OLTP database, does not make full use of multiple CPU cores.

As a result, even if more CPU cores are added to the specification, the query still becomes quite slow when the data exceeds 500 gigabytes.

You may wonder, isn't cloud migration supposed to solve that problem?

We have to increase concurrency while decreasing latency to resolve the problem.

Then, there's Parallel Query, a technique for increasing the execution speed of SQL queries by dividing the workload of a SQL statement and executing it in parallel or at the same time.

At the time of its initial release, PolarDB for MySQL included the Parallel Query function, allowing PolarDB to break the limits of single-core execution performance and take full advantage of multiple CPU cores with parallel processing capabilities, reducing the time required to run some SQL queries on PolarDB exponentially.

Each query is executed by multiple threads in parallel to reduce the processing time (including IO and CPU computation) to achieve a significant decrease in response time.

Watch the full video here to learn more about PolarDB >>

_

0 0 0
Share on

ApsaraDB

202 posts | 17 followers

You may also like

Comments

ApsaraDB

202 posts | 17 followers

Related Products

  • PolarDB

    PolarDB is a cloud-native relational database compatible with MySQL, PostgreSQL, and Oracle.

    Learn More
  • PolarDB-X

    Designed to address database challenges such as ultra-high concurrency, massive data storage, and large table performance bottlenecks.

    Learn More
  • Database for FinTech Solution

    Leverage cloud-native database solutions dedicated for FinTech.

    Learn More
  • Lindorm

    Lindorm is an elastic cloud-native database service that supports multiple data models. It is capable of processing various types of data and is compatible with multiple database engine, such as Apache HBase®, Apache Cassandra®, and OpenTSDB.

    Learn More