MySQL 5.7.14 was officially released yesterday. So, it’s time to check what bugs reported by MySQL Community in public were fixed in this release. Some of these bugs are presented below.As usual, let me start with InnoDB. The following bugs were fixed there:Bug #80296 – “FTS query exceeds result cache limit”. It was reported (for 5.6, but I do not see new 5.6 release notes yet) by Monty Solomon and verified by Umesh.Bug #80304 – “generated columns don’t work with foreign key actions”. It was reported by Guilhem Bichot based on test case by Peter Gulutzan presented here.As most community bug reports during last 2-3 years, it was verified by Umesh.Bug #80298 – “Full-Text queries with additional secondary index gives NULL or Zero rows”, was reported by Ray Lambe and verified by Umesh.Bug #76728 – “reduce lock_sys->mutex contention for transaction that only contains SELECT”. This old bug report by Zhai Weixiang (who had provided a patch) was verified by Sinisa Milivojevic.Bug #80083 – “Setting innodb_monitor_enable to ALL does not enable all monitors”. It was reported by Davi Arnaut and verified by Miguel Solorzano.Bug #79772 – “Foreign key not allowed when a virtual index exists”. It was reported and verified by Jesper wisborg Krogh from Oracle.There are many more bugs fixed in InnoDB, but all of them were reported in internal Oracle’s bugs database by Oracle employees. I do not like this trend.Now, let’s check replication bugs that were fixed:Bug #79324 – “Slave is ~10x slower to execute set of statements compared to master RBR”, was reported by Serge Grachov and verified by Umesh.Bug #62008 – “read-only option does not allow inserts/updates on temporary tables”. This bug was reported long time ago by Ivan Stanojevic and verified by me when I worked in Oracle.It’s really good to see it fixed now!Some bugs were fixed in Performance_Schema (who could imagine it has bugs…), but they were either reported internally or remain private, like Bug #81464. Just take into account that SELECT from some P_S tables could crash server before 5.7.14, based on release notes… This time I see several build-related bugs fixed, like these:Bug #81274 – “Add support for Solaris Studio 12.5 aka 5.14”. It was reported (and probably fixed) by Tor Didriksen.Bug #81593 – “adapt to gcc 5.3 on solaris”. It was also reported and fixed by Tor Didriksen. personally I am happy to see that Oracle still cares about Solaris and related software. Historical sentiments…Bug #80996 – “correct make_pair for c++11 (contribution)”. This fix was contributed by Daniel Black. Bug #80371 – “MySQL fails to build with new default mode in GCC6”. It was reported by Terje Røsten. The last but not the least, I also have to mention this bug in audit (and, thus, query rewrite) plugins, Bug #81298 – “query rewrite plugin suffers scalability issues”. It was reported by Vadim Tkachenko and verified by Sinisa Milivojevic. This is a great improvement.To summarize, I see reasons to upgrade for those who rely a lot on FTS indexes in InnoDB, replication, audit plugins and Performance_schema. I had not even tried to build 5.7.14 from source yet, so I do not have any personal experience to share.
I made some improvements to the ‘proxy’ inside of MySQL 5.7 that I’ve created for WarpSQL (Shard-Query 3). I’ve made the MySQL proxy/shim pluggable and I moved the SQLClient to sql/sql_client.cc. I’ve merged these changes into ‘master’ in my fork.Now you can create “SQL shim” plugins (SHOW PASSWORD is implemented in plugin/sql_shim) and install them in the server like regular plugins:
— command doesn’t work
mysql> show password;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘password’ at line 1
— install the example sql_shim plugin:
mysql> install plugin sql_shim soname ‘sql_shim.so’; Query OK, 0 rows affected (0.00 sec)
— now the command works
mysql> show password;
1 row in set (0.00 sec)
There can be only one!There may only be ONE “SQL shim” plugin running in the server at one time. All “SQL shim” plugins must use the plugin name “sql_shim”. This prevents more than one “SQL shim” plugin from being utilized at once. This is by design, because the MySQL plugin interface doesn’t make any provisions for plugin execution order. If you install a SQL shim plugin by another name, it won’t cause harm, but it will not be utilized.
In this blog post, we’ll look at the MariaDB 10.2 CHECK and DEFAULT clauses. MariaDB 10.2 includes some long-awaited features. In this blog, we are going to discuss the improvements to some table definitions: the DEFAULT clause and the CHECK constraints. These clauses describe columns default values and rules for data validation. Note that MariaDB […]
In this report from Burning Glass, the top in demand coding skills listed are for SQL and Java.
They found 5 great reasons to build your career in
are in high demand
MySQL Installer 5.7 (5.7.14 GA, published on Friday, 29 Jul 2016)
MySQL Community Server 5.6 (5.6.32 GA, published on Friday, 29 Jul 2016)
The Oracle Database 12c Administrator Certified Master exam is now available for scheduling.
– Check the schedule in your region.
– If there is not an event scheduled, select the option to ‘register a request’.
Percona announces the release of Percona Monitoring and Management 1.0.2 Beta on 28 July 2016. Like prior versions, PMM is distributed through Docker Hub and is free to download. Full instructions for download and installation of the server and client are available in the documentation. Notable changes to the tool include: Upgraded to Grafana 3.1.0. Upgraded to […]
Join Brent Compton, Kyle Bader and Yves Trudeau on August 2, 2016 at 10 am PDT (UTC-7) for a MySQL and Ceph webinar. Many operators select OpenStack as their control plane of choice for providing both internal and external IT services. The OpenStack user survey repeatedly shows Ceph as the dominant backend for providing persistent storage volumes […]