))
How TiAdvisor addresses challenges with database indices
Manage episode 401055053 series 3490887
Content provided by Brian Foster, Daniel van Eeden, and Ray Paik, Brian Foster, Daniel van Eeden, and Ray Paik. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Brian Foster, Daniel van Eeden, and Ray Paik, Brian Foster, Daniel van Eeden, and Ray Paik or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://ro.player.fm/legal.
In this episode, Ahmad Ghazal (Distinguished Engineer at PingCAP) returns to Data in the Hallway and to discuss #database indices, why they're important, and how TiAdvisor automates #index discovery to enhance user workload performance.
- TiAdvisor blog post: https://www.pingcap.com/blog/introducing-tiadvisor-automated-tidb-index-discovery/
- TiAdvisor on GitHub: https://github.com/pingcap/index_advisor
[00:00] Introductions
[01:40] What are database indices and why are they imporant?
[05:47] How are database indices usually created and what are some of the challenges?
[12:18] What are the goals of TiAdvisor and how does it work?
[18:08] What's the output of TiAdvisor?
[21:40] Where can people find examples of TiAdvisor in action?
[23:00] What's the best way for community members to reach out with questions or feedback?
[24:20] What are winters like in Southern California?
If you have any feedback or suggestions for episodes, you can email us at podcast@pingcap.com.
————————— About PingCAP and TiDB —————————
PingCAP is the creator of #TiDB, an advanced, #OpenSource, #DistributedSQL database with #MySQL compatibility. TiDB powers modern applications with a streamlined tech stack, elastic scaling, real-time analytics, and continuous access to data—all in a single database.
————————— Developer resources —————————
💫TiDB Twitter: https://twitter.com/TiDB_Developer
💫Introducing TiDB: https://youtu.be/_QBrPBwFoWM
💫Quick start with TiDB: https://docs.pingcap.com/tidb/stable/quick-start-with-tidb
💫TiDB in #Kubernetes: https://docs.pingcap.com/tidb-in-kubernetes/stable
————————— Connect with PingCAP —————————
🔹Twitter: https://twitter.com/PingCAP
🔹LinkedIn: https://linkedin.com/company/pingcap
🔹Facebook: https://facebook.com/pingcap2015
🔹Slack: https://slack.tidb.io/invite?team=tidb-community&channel=everyone&ref=pingcap
🔹GitHub: https://github.com/pingcap
36 episoade
Distribuie
