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 >>
Cloud Forward Episode 2: Cloud-Native Database - PolarDB | Global Database Network
Cloud Forward Episode 4: Cloud-Native Database - PolarDB | HTAP (In-Memory Column Index)
ApsaraDB - August 10, 2022
ApsaraDB - August 9, 2022
ApsaraDB - August 9, 2022
ApsaraDB - August 10, 2022
ApsaraDB - August 10, 2022
ApsaraDB - August 10, 2022
PolarDB is a cloud-native relational database compatible with MySQL, PostgreSQL, and Oracle.
Learn MoreDesigned to address database challenges such as ultra-high concurrency, massive data storage, and large table performance bottlenecks.
Learn MoreLeverage cloud-native database solutions dedicated for FinTech.
Learn MoreLindorm 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 MoreMore Posts by ApsaraDB