Back To Schedule
Tuesday, October 20 • 18:00 - 18:30
Analytical Queries in MySQL

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.

MySQL's sweet spot is known to be online transaction processing (OLTP), and it can support a very high load of short transactions. Many users will also want to run analytical queries (OLAP) on their MySQL data. Often they achieve this by exporting their data to another database system that is tailored for analytical queries. However, this introduces overhead and delay that can be avoided by running your analytical queries directly in your MySQL database.

This presentation will discuss how you can tune your complex analytical queries to achieve better performance with MySQL. We will look at some of the queries from the well-known TPC-H/DBT-3 benchmark, and show how we can improve the performance of these queries through query rewrites, optimizer hints, and improved configuration settings. We will also compare the performance of these queries to other database systems like MariaDB and PostgreSQL, and discuss how MySQL could be improved to better support these queries.

Further Information
While this presentation will mainly focus on MySQL, we will also compare with MariaDB and Postgres and discuss what causes the difference in performance between the systems.

avatar for Øystein Grøvlen

Øystein Grøvlen

Senior Staff Engineer, Alibaba
Ø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... Read More →

avatar for Michael Coburn

Michael Coburn

Principal Architect, Percona
Michael joined Percona as a Consultant in 2012 after having worked with high volume stock photography websites and email service provider platforms. With a foundation in Systems Administration, Michael acted as Product Manager responsible for Percona Monitoring and Management (PMM... Read More →

Tuesday October 20, 2020 18:00 - 18:30 EDT
  MySQL, Application Development
  • Difficulty Advanced
  • Core Technology MySQL
  • Why this level of difficulty? Query optimization is in itself a pretty advanced topic, and I think many advanced users at Perconal Live will appreciate a presentation that increase their knowledge about optimization topics.
  • Speaker Location USA