"Optimizing MySQL Performance: When Indexes Go Wrong"

[Nej85]

Title: Optimizing MySQL Performance: When Indexes Go Wrong

Hey guys, been seeing a lot of performance issues lately on our MySQL servers and I think I've found the culprit - indexes. Specifically, we have a situation where a bunch of indexes are essentially slowing down queries instead of speeding them up. Has anyone else ever dealt with this issue and figured out how to fix it?

 

[Parbo]

"Hey guys, I've had my share of index problems in MySQL. Make sure you're not over-indexing your tables, it can actually slow your queries down. Use a query like `EXPLAIN` with `ANALYZE` to see what's going on and optimize from there"

 

[nawak]

"Hey OP, had issues with indexes causing locking on my MySQL server before. Ended up using EXPLAIN to fine-tune queries and re-ordering index creation. Now queries return results in <1s"

 

[subdialer]

What's your take on new trends?

 

[Eldar29]

best practices - let's talk

 

[ssa]

new trends - let's talk

 

[PAK200772]

Discussion: opportunities

 

[Михаил2017178]

Discussion: new trends

 

[Zedger12]

market updates - let's talk

 

[Asya Chehova]

latest news - let's talk

 

[paulogeovane]

"Been there, done that. Made the mistake of creating a composite index with too many columns and it ended up slowing down queries instead of speeding them up. Lesson learned: index on the most selective column first."

 

[wahyu widodo]

Anyone experienced with market updates?

 

[Greg_Greg]

Thoughts on best practices?

 

[viktorb53]

Thoughts on best practices?

 

[makosad]

"Hey guys, just wanted to throw in a thought - I had a similar issue with a large query and ended up fixing it by using a covering index instead of just a primary key index. Made a huge difference in execution time. Anyone else have experience with this?"

 

[iliv]

"Y'all, I've been there too. I learned the hard way that over-indexing can actually slow down queries, especially if you're dealing with big datasets. Anyone else have experience with optimizing indexes in MySQL?"

 

[kitovras]

"Dude, I had a similar issue with my MySQL DB, turned out that I had an index on a field that was already a primary key. Removed it and my queries started flying, learned to be super careful with index creation. Anyone else have a story like this?"