Parallel Query Execution in POLARDB for MySQL

Thursday 11:00 AM - 11:50 AM

@ Hill Country B

Open Source Databases

50 minutes conference

Intermediate

Tracks:
MySQL

The upcoming version of POLARDB supports parallel execution of SQL queries.

In this presentation, we will show how query execution times may be significantly improved by using multiple threads to scan a table or index in parallel. Each thread will be able to do filtering and aggregation in order to reduce the amount of data to be processed by the query coordinator. Parallel join execution is also supported. We will discuss which type of queries will benefit from this feature and present results that show performance and scalability characteristics. We will also show how to control the degree of parallelism for a query and discuss other aspects of tuning parallel queries.


Speakers

Øystein Grøvlen

Øystein Grøvlen (Alibaba Cloud)

Senior Staff Engineer

Biography:

Øystein Grøvlen is a Senior Staff Engineer in Alibaba Cloud, where he works in the Database Products Group.

Before joining Alibaba, Øystein worked for 10 years in the MySQL optimizer team at Sun/Oracle. At Sun Microsystems, he was also a contributor on the Apache Derby project and Sun's Architectural Lead on Java DB. Prior to that, he worked for 10 years on development of Clustra, a highly available DBMS.

Øystein has been talking about the MySQL Optimizer at several conferences over the years. Dr. Grøvlen has a PhD in Computer Science from the Norwegian University of Science and Technology. Øystein is a native Norwegian, but currently lives in Hangzhou, China.


Benny Wang

Benny Wang (Alibaba Cloud)

Staff Engineer

Biography:

Benny Wang is a Staff Engineer in Alibaba Cloud, where he works in the Database Products Group.
Before joining Alibaba, Benny worked for 3 years in the MySQL optimizer team at Oracle. Benny has been working on database optimizer for almost 10 years. Worked on both Mysql and PostgreSQL optimizer during the past few years.


Slides



  Download Slides  

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863