[thelist] tuning MySQL
Mattias Thorslund
mattias at thorslund.us
Wed Nov 29 15:09:43 CST 2006
Edwin Martin wrote:
> 1) Add one or two indexes (on tbl_one.id and optionally tbl_two.id).
>
+1 on indexes, they often have dramatic effect on slow queries. Do an
"explain" of your query and send us what you get. The output will give
some clues about the best indexes to try.
EXPLAIN (your select query)
> 2) If you do a lot of updates in a row, you can "wrap" them in a single
> update, speeding up the database a lot.
>
+1 An obvious one.
Mattias
More information about the thelist
mailing list