How TiAdvisor addresses challenges with database indices

Explicit content warning

02/14/24 • 26 min

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

TiAdvisor blog post: https://www.pingcap.com/blog/introducing-tiadvisor-automated-tidb-index-discovery/
TiAdvisor on GitHub: https://github.com/pingcap/index_advisor

Previous Episode

More than 20 years of conversation with database users

In this episode, Nabil Nawaz (Principal Solutions Engineer from PingCAP) shares his experience from more than two decades of work with database customers. He also talked about what adjustments he had to make for working at an open source software company.
You can also listen on your favorite podcast platforms such as Apple Podcast, Spotify, etc. For a full list of podcast platforms, you can check out https://datainthehallway.buzzsprout.com/.
If you have any feedback or suggestions for episodes, you can email us at [email protected].

Next Episode

All about SCaLE (Southern California Linux Expo)

In this episode, Ilan Rabinovitch joins us to talk about the history of @socallinuxexpo
(Southern California Linux Expo) including the early days of the event, how it evolved since 2002, and advice he has for people who may be attending the conference for the first time.
PingCap is also one of the sponsors for the #mysql Track at this year's SCaLE.

SCaLE event page: https://www.socallinuxexpo.org/scale/21x
Check out the MySQL track schedule at: https://www.socallinuxexpo.org/scale/21x/schedule/friday
50% discount code for registration: ping

[00:00] Introductions
[00:52] How SCaLE conference got started and the event culture
[05:47] What kinds of people will you meet at SCaLE?
[17:25] Other community events at SCaLE (e.g., #kubernetes, #postgres. #devops Day LA, etc.)
[20:41] Decision making process for adding new tracks or inviting other communities to SCaLE
[27:45] Suggestions for people who are attending SCaLE for the first time
[32:00] #nyc travel tips
If you have any feedback or suggestions for episodes, you can email us at [email protected].