Profiling #MySQL and #MariaDB Hash Join Implementations- Jim Tommaney – #Percona Live Online 2020

Comment 💬, Share 🔗, Like 👍🏻, and Subscribe ✅ to our channel + Turn on the 🔔

Hash Joins are a foundational join technology, now available in #MySQL!

* No index maintenance overhead.Can be orders of magnitude faster.Available for ad-hoc workloads and ETL.
* Great complement to index join operations.

However, the underlying implementation is fundamentally different and introduces additional tweaks to optimize performance.
This presentation will give you the tools to learn when to use Hash Joins and the settings to maximize performance. Hash Joins complement index-join operations: learn the sweet spot for each and what drives that trade-off. This will include a feature comparison across data technologies including #MySQL, #MariaDB, and #Postgres to help understand which Hash Join features have been successfully implemented, what features may need additional work, and what features should be prioritized on the A great roadmap.

📺Subscribe To Our Channel and Get More information about #OpenSource #Databases, #kubernetes and many other things.
https://www.youtube.com/c/percona?sub_confirmation=1

You can find more about #Mariadb and #Mysql support #Databases in these links 👇🏻👇🏻👇🏻

https://www.percona.com/services/support/mysql-support
https://www.percona.com/services/support/mariadb-support
https://www.percona.com/blog/

Connect With us on our Social Networks 👇🏻👇🏻👇🏻
Follow Percona on Twitter: https://twitter.com/Percona
Follow Percona on Facebook: https://www.facebook.com/Percona
Follow Percona on Instagram: https://www.instagram.com/percona_llc/
Follow Percona on LinkedIn: https://www.linkedin.com/company/percona/