W3cubDocs

/MariaDB

Stuff in MySQL 5.6

This is SergeyP's list of patches in MySQL 5.6 that he has found interesting. It is not a full list of interesting features or anything like that

WL#6071: Inline tmp tables into the nested loops algorithm. (Evgen, 2012-05-31)

WL#4443 - Prune partition locks (public WL) (April 2012)

WL#4897: Add EXPLAIN INSERT/UPDATE/DELETE (2011)

  • EXPLAIN EXTENDED UPDATE doesn't print warnings...

WL#5906 read before write removal (RBWR) (2012-04)

  • used by NDB only. (Bug#37153 NDB Cluster reports affected rows incorrectly, etc)
  • but the SQL layer still does reads before doing writes. This code is not suitable for update-without-reads.
  • The main idea is that we do [deleted|updated]= table->file->end_read_removal(); at the end. This only counts #of affected rows.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2023 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/stuff-in-mysql-56/