content/data-base/Q&A: Even More Deadly Mistakes of MySQL Development.md

---

Title: "Q&A: Even More Deadly Mistakes of MySQL Development" Date: 2016-12-16 17:20:00 Categories: [data base] tags: [mysql, mariadb, percona]

Authors: sedlav

Bill Karwin provides a guide on "How to Avoid Even More Common (but Deadly) MySQL Development Mistakes". Here are some of the questions answered by Bill Karwin:

• How many tables can be joined in a single query? What is the optimal number of joins?
• How many indexes can be created in a single table? Any limitation? What is the optimal number of indexes?
• How to detect when too much indexes start to affect performance?

Link