Duplicate Indexes in MySQL and more

Update: 2024-11-15

Description

In this podcast, we’ll explore the issue of duplicate indexes in MySQL; including redundant index, foreign keys, left-prefixed secondary index /w primary key, and how to tackle the issue at hand.

Reference: https://kedar.nitty-witty.com/blog/podcast-duplicate-indexes-in-mysql

Comments

In Channel

MySQL InnoDB Cluster Group Replication - Part 7 - Key Concepts in MySQL Group Replication InnoDB Cluster

2025-09-0617:54

MySQL InnoDB Cluster Group Replication - Part 6 - Comparing InnoDB Cluster with Other HA Solutions

2025-09-0323:16

MySQL InnoDB Cluster Group Replication - Part 5 - Limitations

2025-07-0715:55

MySQL InnoDB Cluster Group Replication - Part 4 - Requirements

2025-07-0707:10

MySQL InnoDB Cluster Group Replication - Part 3 - Use Cases

2025-07-0716:10

MySQL InnoDB Cluster Group Replication - Part 2 - Introduction to InnoDB Cluster

2025-07-0706:26

MySQL InnoDB Cluster Group Replication - Part 1 - Introduction

2025-07-0708:23

MySQL Archiving Basics - considerations, mistakes, best practices

2025-04-1312:56

Choosing ProxySQL Versions

2025-03-0410:11

Useful scripts for MySQL in Percona Toolkit

2024-11-2917:24

MySQL Replication Basics - Part 3 Replica Lag

2024-11-2921:13

MySQL Replication Basics - Part 2 binary logs and more

2024-11-2010:58

MySQL Replication Basics - Part 1

2024-11-2017:50

Low Hanging Fruits of MySQL Performance

2024-11-1524:08

Duplicate Indexes in MySQL and more

2024-11-1515:05

MySQL Change Buffer - A discussion and FAQ

2024-11-1523:31

00:00

1.0x

Duplicate Indexes in MySQL and more

#box-pro-ellipsis-176550179734656{-webkit-line-clamp:2;}Duplicate Indexes in MySQL and more

Duplicate Indexes in MySQL and more

Kedar Vaijanapurkar

Duplicate Indexes in MySQL and more