The latest from the MySQL community

subtitle: How to use awk to filter binlogs for specific tables

The task: Find out how many inserts were done to a set of tables over a period of time. Specifically avg inserts/min, avg inserts/hour, avg inserts/day, for the past week. Seems simple, right?

I was surprised that there was no good way to get what was done to a specific table, for data gathering AND forensic purposes!

These tables are be deleted from, so just using rows and timestamps is not valid. We have binary logs, which log when an insert was done. My first thought was to use pt-query-digest, since the tool has a “Tables” section in the output, so it already parses out which tables are in a query.

Sadly, tables is not an attribute I can --filter on, at least not in my version of pt-query-digest. (insert sad trombone here)

Do you want to hear how popular, innovative and leading companies are using MySQL to scale their large workload ? Join Oracle Open World to learn from these successful players how to achieve strong business constraints using the most popular Open Source database !

We have the honor to welcome some of the most famous companies in the Web and host their sessions or invite them on stage during our keynote !

Facebook and Booking.com will share their experience during Rich Mason and Tomas Ulin keynote on Monday Oct 2nd in the Marriott Marquis, room Golden Gate A at 4.45PM.

Booking.com’s engineers will also propose sessions on Tuesday, Oct 3rd …

Like every year, the a MySQL Community Reception will take place during Open World.

If  you are using or interested in learning more about MySQL? And if  you are attending Oracle OpenWorld and looking for an opportunity to meet and exchange ideas or experiences with MySQL users? Then join the MySQL team on Tuesday, October 3rd at Jillians to celebrate the dynamics and growth of the MySQL community!

Whether you are attending OpenWorld, a member of local MySQL user groups, a MySQL user in the Bay Area, or simply interested in MySQL technology, you’re all invited to Oracle’s MySQL Community Reception.

• Mingle with your peers and learn from real-world experiences.
• Talk to MySQL engineers face-to-face and get the first-hand information on the latest product development. …

Great news! MySQL 8.0.3 is out and it is a release candidate. In the replication team we have been busy working on interesting new enhancements and also doing some clean up. Some of these new features are out in this release.…

This blog post will give a brief overview of Amazon RDS capabilities and limitations, and how Percona Support can help you succeed in your Amazon RDS deployments.

One of the common questions that we get from customers and prospective customers is about Percona Support with Amazon RDS. As many companies have shifted to the cloud, or are considering how to do so, it’s natural to try to understand the limitations inherent in different deployment strategies.

Why Use Amazon RDS?

As more companies move to using the cloud, we’ve seen a shift towards work models in technical teams that require software developers to take on more operational duties than they have traditionally. This makes it essential to abstract infrastructure so it can be interacted with as code, whether through automation or APIs. Amazon RDS presents a compelling DBaaS product with significant flexibility while maintaining ease of deployment.

Use …

Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter.

This blog post is with Alexey Kopytov, sofware developer and maintainer of sysbench. His talk is Modern sysbench: Teaching an Old Dog New Tricks. His presentation present new features provided by recent releases and explain how they can be used to create complex benchmark scenarios and collect performance metrics with a simple Lua API. It will also run a live demo of some of …

The MySQL Development team is very happy to announce that MySQL 8.0.3, the first 8.0 Release Candidate (RC1), is now available for download at dev.mysql.com (8.0.3 adds features to 8.0.2, 8.0.1 and 8.0.0). The source code is available at GitHub.…

OOW17 is just around the corner. And again this year the MySQL team is very proud to present you their work mostly on MySQL 8.0 but also on NDB and all Enterprise tools we have. This year, we will also focus on the place MySQL has in Oracle’s Cloud !

Of course MySQL’s Community is also present in the schedule with very interesting talks. The full schedule related to the MySQL sessions can be found here.

Let’s focus on the agenda for the event:

Sunday, October 1st Moscone South Room 160

• …

In this blog post, I will demonstrate how to run and use sysbench histograms.

One of the features of sysbench that I often I see overlooked (and rarely used) is its ability to produce detailed query response time histograms in addition to computing percentile numbers. Looking at histograms together with throughput or latency over time provides many additional insights into query performance.

Here is how you get detailed sysbench histograms and performance over time:

sysbench --rand-type=uniform --report-interval=1 --percentile=99 --time=300 --histogram --mysql-password=sbtest oltp_point_select --table_size=400000000 run

There are a few command line options to consider:

• report-interval=1 – prints out the current performance measurements every second, which helps see if …

Percona announces the release of Percona XtraDB Cluster 5.6.37-26.21 on September 20, 2017. Binaries are available from the downloads section or our software repositories.

Percona XtraDB Cluster 5.6.37-26.21 is now the current release, based on the following:

• Percona Server for MySQL 5.6.37-82.2
• Galera Replication library 3.21
• wsrep API version 26

All Percona software is open-source and free.

…