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 [email protected]. —————————  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