Both as a "developer Milestone Release 5.6.3" as well as "DMR 5.6 # 2"
designated pre-release version of MySQL 5.6 on Oracle introduced its
open-world conference. This is primarily a revision of the optimizer
have experienced. This now leads some MySQL queries up to three times
faster, Rob Young writes in a blog post.
Particularly hard hit are the queries that can be the result of using
ORDER BY to sort a column without an index and can spend only a few
lines by LIMIT. Here, the server sorts the entire result set so far. The
modification should be done in future only for the really needed lines.
Give significant performance gains, it also the fact that the storage
engine performs certain index-oriented operations themselves.
In addition, the developers explain the commands for INSERT and UPDATE
commands extended and equips it with a TRACE option. This can be traced
in detail the decisions of the optimizer.
Milestone's version of MySQL is in the download section of the developer
site is available.
Update: The reference to the query by limiting the LIMIT was missing in
the original text. This created the false impression that always leads
ORDER BY to sort the entire table.
No comments:
Post a Comment