Q&A: Even More Deadly Mistakes of MySQL Developmentmariadb, mysql, percona
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?