Data in the Hallway

How TiAdvisor addresses challenges with database indices

Brian Foster, Daniel van Eeden, and Ray Paik Episode 17

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

People on this episode