Link You Today [Bookmark your Free, Libre software & tech link]

Q&A: Even More Deadly Mistakes of MySQL Development

mariadb,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?

Link

Related Post