MySQL 5.7.10, the first release after MySQL
5.7 GA announcement, appeared almost a week ago. It's interesting
to check what bugs reported by MySQL Community were fixed in this
version, hence this post (that had to wait during the weekdays
busy with usual support work). As usual, I'll concentrate mostly
on InnoDB, replication and optimizer-related bug fixes and
highlight names of those who reported and verified each
Let's start with InnoDB. The following bugs reported by MySQL Community users were fixed:
This Log Buffer Editions picks few blog posts from Oracle, SQL Server and MySQL.
Recently, I happened to have an onsite engagement and the goal of the engagement was to move a database service to RDS Aurora. Like probably most of you, I knew the service by name but I couldn’t say much about it, so, I Googled, I listened to talks and I read about it. Now that my onsite engagement is over, here’s my first impression of Aurora.
First, let’s describe the service itself. It is part of RDS and, at first glance, very similar to a regular RDS instance. In order to setup an Aurora instance, you go to the RDS console and you …[Read more...]
These days everybody is excited with recent announcement of
MySQL 5.7.9 GA release. If you are not aware
of this event yet (I've noted it from numerous posts even during
my short vacation), wait for the Oracle Open World 2015 to begin tomorrow to
announce it even wider and louder!
I already have 5.7.9 built from source, up and running, so it's time to check what else we can expect from this new GA release besides new great features (this is a topic for a …
People at Intel started the pmem library project some time ago, it’s open to the broader community at GitHub and other developers, including Linux kernel devs, are actively involved.
While the library does allow interaction with an SSD using a good-old-filesystem, we know that addressing SSD through SATA or SAS is very inefficient. That said, the type of storage architecture that SSD uses does require significant management for write levelling and verifying so that the device as a whole actually lasts, and your data is kept safe: in theory you could write to an NVRAM chip, and not know when it didn’t …[Read more...]
I often have to reply to questions related to upgrade from, say,
MySQL 5.5.x to latest MySQL (or Percona) Server 5.6.x (5.6.27 for
MySQL and 5.6.26 for Percona at the moment). One of them is
sometimes about "any known bugs" that may affect a user after
One may assume that now, 2 years and 8 months after the first GA release of MySQL 5.6.10, there should be very few bugs (we call them regression bugs) of a kind that is interesting for the user planning upgrade from 5.5.x. I checked yesterday and found out it's not the case actually. It took me half an hour to end up with the list of more than 20 regression bugs that are …
MySQL 5.6.27 was released on September 30
formally. Source code is also available on GitHub, and I have it compiled (some users are
less lucky) and running for a couple of days
already. In this post I'll comment on some bugs reported by MySQL
Community that are fixed there.
I'd like to start with a couple of bugs where patches were also contributed. First of all, the fix suggested by Stewart …
Indexes are separate data structures that provide alternate
pathways to finding data. They can and do generally speed up the
processing of queries and other DML commands, like the
DELETE statements. Indexes are also
called fast access paths.
In the scope of the InnoDB Database Engine, the MySQL database
maintains the integrity of indexes after you create them. The
upside of indexes is that they can improve SQL statement
performance. The downside is that they impose overhead on every
INTO, and …
Recently Aphyr (Kyle Kingsbury) published https://aphyr.com/posts/327-call-me-maybe-mariadb-galera-cluster
The article is technically valid, I am not going to dispute a conclusion Aphyr made, but it is also quite technically involved, so users who just jump to conclusion may get the wrong impression and we’re left with more questions than ever.
So, let me state what is the real conclusion of this
“Galera cluster does not support
LEVEL, in contract to what was stated in the …