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 …

NetProspex is a B2B platform that enhances lead generation by separating the information that matters and enabling marketers to better segment and target their audience. Managing the massive amount of incoming data is cumbersome for one DBA.

In the past, NetProspex used tools like Nagios and MySQL Enterprise Monitor (MEM), but both fell short of the company’s monitoring needs. Hiring another DBA was both difficult and expensive, so Josh Prunier, DBA at NetProspex, began evaluating alternative solutions. VividCortex’s MySQL-specific query intelligence was better suited.

VividCortex made an immediate positive impact on Josh’s workload and overall operations by improving insight into query and server behavior and reducing overhead costs. The ability to compare and analyze queries allows Josh to proactively examine queries that are not written efficiently and take actions such as tweaking an index or the query syntax. The deep …

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 …

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 …

Download PDF Presentation

Thank you to Jon Day and Jaimee Swiderski from MariaDB for the organization and presentation of “MaxScale is now GA” to our New York MySQL meetup group.

For those that are not familiar with MaxScale in the MySQL ecosystem, from the initial slides:

What is MaxScale?

The simple answer is a classical proxy that sits between the database clients and servers forwarding requests and responses.
The more detailed answer is a proxy platform for building highly tailored and …

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:

1. My agenda for MySQL NoSQL Cloud 2013 On October 15 and 16 I'll take the ferry to...
2. Using MySQL Proxy to benchmark query performance By transparently sitting between client and server on each …

To operate any database efficiently, you need to have insight into database performance. This might not be obvious when everything is going well, but as soon as something goes wrong, access to information can be instrumental in quickly and correctly diagnosing the problem.

All databases make some of their internal status data available to users. In MySQL, you can get this data mostly by running 'SHOW STATUS' and 'SHOW GLOBAL STATUS', by executing 'SHOW ENGINE INNODB STATUS', checking information_schema tables and, in newer versions, by querying performance_schema tables.

These methods are far from convenient in day-to-day operations, hence the popularity of different monitoring and trending solutions. Tools like Nagios/Icinga are designed to watch hosts/services, and alert when a service falls outside an acceptable range. …

One of the important optimisations we did in MySQL Cluster 7.4 was to
use more of direct function calls as part of SCAN processing instead of
relying on asynchronous messages.

We want each message execution to be short, up to around 10
microseconds of execution per message we should strive to
keep it below. However if we decrease the time spent executing
a message to down to a microsecond or smaller than we spend too
much time in the message scheduler. So it is important to strike a
balance here.

For primary key lookups we do most of the work in one message
execution, so here we already were doing the optimal behaviour
in our model of execution.

For scans however we often scan hundreds or even thousands and
in some cases even millions of rows, so here there is a lot of
opportunity to decide how to execute the scan.
…

DZone recently released the Guide to Database and Persistence Management. The Guide includes articles by thought leaders around the industry, including our CEO Baron Schwartz. It is a privilege to be included in such a publication with other luminary acolytes.

Download the full copy here, and check out page 14.

The State of the Storage Engine provides insight into the rapidly shifting landscape of data storage. It addresses why the standard textbook architecture is now being questioned and analyzes alternatives to the venerable B-tree Index, including the growing trend of log-structured merge trees.

Of course, no matter the underlying storage, there lies the classic iron triangle trade-off:

“You can have sequential reads without amplification, sequential …