Our friends at Datadog just published an insanely great three part series on monitoring Amazon RDS for MySQL using Datadog. You should go read that now.

Full disclosure, I helped review a couple of the drafts. (We don’t have any formal relationship, we’re just friends–although we do integrate VividCortex with Datadog for our customers).

My only suggestion for monitoring RDS+MySQL above and beyond what Datadog wrote is that query monitoring is vital. Your databases exist to run queries, so you really ought to monitor their performance! However that doesn’t really make sense for Datadog, since it isn’t a query centric monitoring platform. …

Many of you are coming to San Francisco next week for Oracle OpenWorld 2015 and many of you have already booked time on your calendars on Wednesday evening before the appreciation event. You are right — the Annual Oracle Bloggers Meetup, one of your favorite events of the OpenWorld, is happening at usual place and time!

What: Oracle Bloggers Meetup 2015.

When: Wed, 28-Oct-2015, 5:30pm.

Where: Main Dining Room, Jillian’s Billiards @ Metreon, 101 Fourth Street, San Francisco, CA 94103 ( …

MariaDB 10.1 shipped a few days ago, so it’s now a good time to focus on another important event. Last week we had a three day MariaDB developers meeting. It took place in Amsterdam (Oct 13-15). Meetings like this tend to have a great impact on the roadmap of the product. Booking.com was very kind […]

The post Developer meeting & community meetup summary appeared first on MariaDB.org.

Oracle OpenWorld can be pretty intimidating. Besides the extra fifty thousand bodies in an around Moscone Center in San Francisco, there is an overload of amazing information that bombards you from all directions. And then comes the really hard decision of which sessions to attend. This year MySQL has three rooms being used for sessions.

The Catalog of sessions shows over 1800 session and MySQL is the subject of fifty three of those. The problem is that you can not be in three places at once!

For example on Monday morning there are two tutorials and a great session at the same time.

• MySQL Essentials—Getting Started with MySQL [TUT2356]
  Ligaya Isler-turmelle, Principle Technical Support Engineer, Oracle
  Jeremy Smyth, Course/Curriculum Developer, Oracle
  …

I love graphs. They just make things easier when it comes to finding patterns. I also love visibility. Having the ability to known what is going on inside the database is priceless. How about having visibility of the slow queries execution time on a graph? Let’s do it.

We’ve already described how to get query digest using performance schema. Since the MySQL server is already doing the heavy lifting for you with little-to-no overhead, this information is available practically at will. So let’s make some graphs with that data.

To accomplish this I will use the well-known tool Graphite to store and render time-series data. For those who are not familiar with Graphite, it’s actually a 3-piece tool, consisting of:

• The …

The Call for Papers for the fifth annual Percona Live Data Performance Conference and Expo (formerly MySQL Conference and Expo) taking place April 18-21, 2016, in Santa Clara, California, is now officially open!

Ask yourself… “Do I have…”

• Fresh ideas?
• Enlightening case studies?
• Insight on best practices?
• In-depth technical knowlege?

If the answer to any of these is “YES,” then you need to submit your proposal for a chance to speak at Percona Live 2016. Speaking is a great way to broaden not only the awareness of your company with an intelligent and engaged audience of software …

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 actually store your data properly.

But there are other technologies, such as Memristor (RRAM) and Phase Change Memory …

This post discuss the pt-table-checksum & error "Waiting to check replicas for differences: 0% 00:00 remain" with a use-case and solution.

The post pt-table-checksum & Waiting to check replicas for differences: 0% 00:00 remain first appeared on Change Is Inevitable.

Oracle today announced the general availability of MySQL 5.7, the latest version of the world’s most popular open source database. The new version delivers greater performance, scalability and manageability, plus enhanced NoSQL capabilities with JSON support and MySQL Router, which makes it easy to connect applications to multiple MySQL databases. Read the press release at:  https://

When it comes to the query tuning, EXPLAIN is one the most important tool in the DBA’s arsenal. Why is a given query slow, what does the execution plan look like, how will JOINs be processed, is the query using the correct indexes, or is it creating a temporary table? In this blog post, we’ll look at the EXPLAIN command and see how it can help us answer these questions.

This is the thirteenth installment in the ‘Become a MySQL DBA’ blog series. Our previous posts in the DBA series include Database Indexing, Deep Dive pt-query-digest, Analyzing SQL …