Analytical Queries in MySQL - Øystein Grøvlen - Percona Live ONLINE - MySQL Tutorial

#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.

Comment 💬, Share 🔗, Like 👍, and Subscribe ✅ to our channel + Turn on the 🔔
📺 Subscribe To Our Channel + Turn on the 🔔 and Get More videos about #OpenSource #Databases, and many other things.

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.

You can find more information about #MySQL #Databases and Percona Database Talks in these links 👇👇👇

Connect With us on our Social Networks 👇👇👇