The MySQL Development Team is happy to announce a new 8.0 Maintenance Release of MySQL Shell AdminAPI – 8.0.20!
Following the previous exciting release, on which InnoDB ReplicaSet was introduced, we focused on improving the management of ReplicaSets but also, most importantly, InnoDB cluster.…
Facebook Twitter LinkedIn
MySQL introduced optimizer hints in version 5.7 and greatly
extended the feature in MySQL 8. One thing that has been missing
though is the ability to specify index hints using the syntax of
optimizer hints. This has been improved of in MySQL 8.0.20 with
the introduction of index-level optimizer hints for the
FORCE and IGNORE versions of the index
hints. This blog will look at the new index hint syntax.
Warning
Do not add index hints – neither using the old or new style –
unless you really need them. When you add index hints, you limit
the options of the optimizer which can prevent the optimizer
obtaining the optimal query plan as new optimizer improvements
are implemented or the data changes.
On …
MySQL Server 8.0.20, 5.7.30 and 5.6.48, new versions of the popular Open Source Database Management System, have been released. These releases are recommended for use on production systems. For an overview of what’s new, please see http://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html http://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html For information on installing the release on new servers, please see the MySQL installation documentation at […]
Dear MySQL users,
MySQL Connector/Python 8.0.20 is the latest GA release version of the
MySQL Connector Python 8.0 series. The X DevAPI enables application
developers to write code that combines the strengths of the relational
and document models using a modern, NoSQL-like syntax that does not
assume previous experience writing traditional SQL.
To learn more about how to write applications using the X DevAPI, see
http://dev.mysql.com/doc/x-devapi-userguide/en/
…
Dear MySQL users,
MySQL Connector/C++ 8.0.20 is a new release version of the MySQL
Connector/C++ 8.0 series.
Connector/C++ 8.0 can be used to access MySQL implementing Document
Store or in a traditional way, using SQL queries. It allows writing
both C++ and plain C applications using X DevAPI and X DevAPI for C.
It also supports the legacy API of Connector/C++ 1.1 based on JDBC4.
To learn more about how to write applications using X DevAPI, see
“X DevAPI User Guide” at
…
Dear MySQL users,
MySQL Connector/ODBC 8.0.20 is a new version in the MySQL
Connector/ODBC
8.0 series, the ODBC driver for the MySQL Server.
The available downloads include both a Unicode driver and an ANSI
driver
based on the same modern codebase. Please select the driver type
you
need based on the type of your application – Unicode or
ANSI.
Server-side prepared statements are enabled by default. It is
suitable
for use with the latest MySQL server version 8.0.
This release of the MySQL ODBC driver is conforming to the ODBC
3.8
specification. It contains implementations of key 3.8
features,
including self-identification as a ODBC 3.8 driver, streaming of
out for
binary types only), and support of the
SQL_ATTR_RESET_CONNECTION
connection attribute (for the Unicode driver only).
The release is now available in source and binary form for a number …
[Read more]Dear MySQL users,
MySQL Connector/Node.js is a new Node.js driver for use with the
X
DevAPI. This release, version 8.0.20, is a maintenance release of
the
MySQL Connector/Node.js 8.0 series.
The X DevAPI enables application developers to write code that
combines
the strengths of the relational and document models using a
modern,
NoSQL-like syntax that does not assume previous experience
writing
traditional SQL.
MySQL Connector/Node.js can be downloaded through npm (see
https://www.npmjs.com/package/@mysql/xdevapi for
details) or from
https://dev.mysql.com/downloads/connector/nodejs/.
To learn more about how to write applications using the X DevAPI,
see
…
The MySQL Development team is very happy to announce that MySQL 8.0.20 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release. Please download 8.0.20 from dev.mysql.com or from the MySQL Yum, APT, or SUSE repositories.…
Facebook Twitter LinkedIn
MySQL 8.0.20 was released April 27th. So what is new? The
details are in the release notes and I would like to point out a
few of the more interesting things, at least to me.
New SHOW_ROUTINE privilege Previously those using routines
had to had the SELECT privilege which in many cases was overly
broad. So for better granularity and control of resources.
Better JSON_TABLETo bring JSON_TABLE into compliance with the
specification, ON EMPTY must now come before ON ERROR where in
previous versions you could the two clauses in any way you
wanted.
Hash JoinsHash joins are now available as Inner non-equi-joins,
Semijoins, Antijoins, Left outer joins, and
Right outer joins.
Double Buffer ImprovementThe InnoDB storage engine area for the
doublewrite buffer was moved from the system …
Dear MySQL users,
The MySQL developer tools team announces 8.0.20 as our General
Availability
(GA) for MySQL Workbench 8.0.
For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?152
The release is now available in source and binary form for a
number of
platforms from our download pages at:
http://dev.mysql.com/downloads/tools/workbench/
Enjoy!