Introduction
The MySQL Optimizer sometimes needs a temporary data-store during
query processing, for storing intermediate results. Before
MySQL 5.7, this need was serviced exclusively using a combination
of the HEAP/MEMORY storage engine (for smaller
tables) and the MyISAM storage engine (for larger
tables). You can find more information on when disk based
temporary tables (MyISAM or InnoDB) are used instead of MEMORY
tables here.
The …
The MySQL Performance Schema exposes so much data that it’s not trivial to learn, configure, and use. With recently released Percona Agent 1.0.11 you can get query metrics – like min, max, and average query execution time – with a few clicks:
Click “Apply” and about two minutes later you’ll have query metrics from Performance Schema, collected and sent every minute.
Percona Cloud Tools (PCT) and Percona Agent handle all the details. You’ll need MySQL (or Percona Server) 5.6 and Percona Agent 1.0.11 or newer. One caveat at the moment: it …
[Read more]
The MySQL Utilities team is happy to introduce a new MySQL
utility named ‘mysqlbinlogpurge‘, which allows users to
easily and safely purge binary logs on a master by determining
the binary logs that are obsolete. This utility is included in
MySQL Utilities
release-1.6.1 Alpha release along with ‘mysqlslavetrx‘ and ‘mysqlbinlogrotate‘. This utility enables you
to purge binary logs by ensuring that any files which are in use
or required by any of the slaves in a replication topology are
not deleted. This is achieved by
checking which binary logs have been read on each slave. This
determines the minimal set of binary log files that …
The MySQL Utilities Team is pleased to announce the general availability (GA) release of MySQL Utilities. This release includes a number of improvements for useabilty, stability, and a few enhancements. A complete list of all improvements can be found in our release notes.
New Enhancements!
This release represents a stable release of the product. Along with several defect patches, we also include the following enhancements.
Improved support for MySQL 5.7 early releases
Improved output for mysqldbcompare
Improved SSL support
How Can I Download MySQL Utilities?
You can download MySQL Utilities 1.5.2 GA from the following link using one of the pre-built installation repositories including a source download.
http://dev.mysql.com/downloads/tools/utilities/
Where is the Documentation?
You …
[Read more]The MySQL Utilities Team is pleased to announce a new alpha release of MySQL Utilities. This release includes a number of improvements for useability, stability, and a few enhancements. A complete list of all improvements can be found in our release notes.
New Enhancements!
This release represents a stable release of the product. Along with several defect patches, we also include the following enhancements.
Improved support for MySQL 5.7 early releases
Improved output for mysqldbcompare
Improved SSL support
New Utilities!
This release also has three new utilities for you to try out:
mysqlslavetrx – skip transactions on one or more slaves to solve
errant transactions and consistency errors – docs
mysqlbinlogpurge – purge old binary logs – docs
mysqlbinlogrotate – rotate the binary logs – docs
How Can I Download MySQL Utilities?
You can …
[Read more]There’s an interesting post over at Olery‘s blog about a successful migration story from using MySQL/MongoDB to PostgreSQL as the persistence layer for applications that, however, lists a couple of cons of using MySQL that I personally think are no longer valid complaints (or at least not as big as they used to be). I did … Continue reading Ongoing MySQL myths →
Related posts:
A much requested feature has made it to MySQL 5.7.6: Global Transaction Identifiers (GTIDs) can now be enabled online, without stopping writes, synchronizing servers, or restarting servers.
We introduced GTIDs in MySQL 5.6.6. GTIDs allow, among other things, seamless fail-over after a master has crashed. This enables highly available applications, since service can continue without interruption even if the master crashes. For new deployments, you could easily enable GTIDs right away – just set gtid-mode=ON in the configuration files. For deployments that accept a certain amount of downtime, you could switch from off to on too. However, for big deployments with strict limitations on downtime, this was more problematic, since you had to stop updates, sync all servers, and restart all servers simultaneously with GTIDs enabled, and this would lead to several minutes of downtime.
In MySQL 5.7.6, we have now made it possible to enable …
[Read more]More Awesome Replication Features in 5.7.6
It is time to celebrate again. The latest MySQL server development milestone (MySQL 5.7.6) was just released, and let me tell you, it is full of great replication enhancements. These new improvements cover many areas, ranging from performance to flexibility and easier deployment. Let me highlight some of them, and give you a brief summary of what they are.
Multi-source Replication
A MySQL 5.7.6 slave/server can now connect to multiple MySQL masters.
After a long development period, two labs releases, handling feedback from community, and a lot of internal (and external testing as well – thank you!), the multi-source replication feature was finally pushed into MySQL 5.7. This is a major milestone for replication itself. The feature allows a single MySQL server to aggregate …
[Read more]
We are very happy to introduce a new MySQL utility named
"mysqlslavetrx", which allows users to easily skip
multiple transactions on multiple servers in a single step. This
utility is one of three new utilities included in MySQL Utilities
release-1.6.1 Alpha. The other utilities are
"mysqlbinlogpurge" and "mysqlbinlogrotate", which
can be used to purge and rotate binary logs.
The mysqlslavetrx utility allows you to skip multiple
transactions on several slaves. More precisely, it injects empty
transactions for the specified Global Transaction Identifier
(GTID) set and list of target slaves. Skipping transactions can
be useful to quickly recover from erroneous situations that can
occur during the replication process, or to handle errant
transactions. Check out the following blog posts for more details
about concrete situations where you might need to inject empty
transactions:
We are very happy to introduce a new MySQL utility named “mysqlslavetrx“, which allows users to easily skip multiple transactions on multiple servers in a single step. This utility is one of three new utilities included in MySQL Utilities release-1.6.1 Alpha. The other utilities are “mysqlbinlogpurge” and “mysqlbinlogrotate“, which can be used to purge and rotate binary logs.
The mysqlslavetrx utility allows you to skip multiple transactions on several slaves. More precisely, it injects empty transactions for the specified Global Transaction Identifier (GTID) set and list of target slaves. Skipping transactions can be useful to quickly recover from erroneous situations that can occur during the replication process, or to handle errant transactions. Check out the following blog posts for more details about concrete situations where you might need to inject empty transactions: …
[Read more]