Data in the Hallway
A podcast series where we discuss community, database, open source, and other topics.
Email us at podcast@pingcap.com for your feedback or suggestions.
Data in the Hallway
How TiAdvisor addresses challenges with database indices
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