MySQL Performance Tuning at COSCUP 2014This document discusses various techniques for optimizing MySQL queries and databases, including: - Using the query cache can speed up repeating queries with the same syntax. - Choosing optimal variable types like integers over strings for size and performance. - Indexing the right columns and testing indexes regularly as tables change. - Using EXPLAIN to check query performance and identify optim
初級〜中級者のためのSQL特訓 - 忘れないようにメモっとく
データベース技術の羅針盤
