In our last post, we showed you how to use pt-stalk to help gather a bunch of data that can be used for troubleshooting. But what type of data does it collect? How do we parse the files to make sense of all that data?

This is the twentieth installment in the ‘Become a MySQL DBA’ blog series. Our previous posts in the DBA series include:

• Troubleshooting with pt-stalk,
• Troubleshooting Galera cluster issues - part 2,
• …

As most of us know, we will have the chance to attend to the MySQL conference in April (from 18 to 21).

For the ones like me that had being there from long, this is a moment of reunion with colleagues and friend. It is also a moment of confrontation and sharing.

In the years this conference had be the moment for the ones surfing the MySQL sea in which things can be put on the table and discuss. Very few matter if it was call MySQL conference or, as it is now Percona Live. What matter is the spirit with which the people participate, and the desire to share.

One of the important aspects was and is, to be able to learn from others experience, innovation and experimentations.

The past year had be a very difficult for me, thankfully only work wise, but I had also be able to be in some interesting exercises, that had allow me to come with a list of proposal that I consider quite …

Performance Schema

In many types of database workloads, using a multi-threaded slave from 5.6+ helps improve replication performance. I’ve had a number of users enable this feature, but have not seen anyone ask how each thread is performing. Here’s a quick way with Performance_Schema to measure the amount of multi-threaded slave activity on each thread (after you have already configured MTS on your slave of course ).

First, we need to enable the 

statements

 instruments:

slave1> UPDATE setup_consumers SET ENABLED = 'YES' WHERE NAME LIKE 'events_statements_%';
Query OK, 2 rows affected (0.00 sec)
Rows matched: 3  Changed: 2  Warnings: 0

Next, let’s find the

THREAD_ID

 for our slave workers:

slave1> SELECT THREAD_ID, …

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.23. See the release notes and changelog for details on this release. Download MariaDB 10.0.23 Release Notes Changelog What is MariaDB 10.0? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB!

The post MariaDB 10.0.23 now available appeared first on MariaDB.org.

As the festive season of holidays draws near, there is a spring in the blogosphere. This Log Buffer edition anticipates that and picks some lively blog posts from Oracle, SQL Server and MySQL.

Oracle:

• Truncate is one of those commands that cannot be undone trivially…In fact, you might well be looking at a database recovery in order to get a truncated table back to a “full” state.
• It should be rare to see many TNS listener processes running on 1 OS. Some listeners are even Global Data Services listener.
• The fact that an extension explicitly created by a user through …

Fri, 2015-12-18 09:01geoff_montee_g

Several months ago, I wrote a blog post about configuring PAM authentication and user mapping in MariaDB. While it is useful to map a system user account to a MariaDB user account, a lot of users actually wanted to be able to map all system users in a particular system group to the same MariaDB user account without mapping the system accounts individually. This was not supported by the PAM user mapping plugin when I wrote the original blog post, but this feature was recently added.

The new group mapping feature of the PAM user mapping plugin allows users to do things like map every system user in the dba system group to the dba MariaDB user account, while still requiring the system …

In the previous post for this ongoing “EXPLAIN FORMAT=JSON is Cool!” series, we discussed covered indexes and how the 

used_columns

  array can help to choose them wisely. There is one more type of multiple-column indexes: composite indexes. Composite indexes are just indexes on multiple columns. Covered indexes are a subgroup of the larger set “composite indexes.” In this post we’ll discuss how “used_key_parts” can help show …

Severalnines ClusterControl Helps Organizations
Deploy, Monitor, Manage and Scale Percona Server for MongoDB

Severalnines, the provider of open source database management tools, and Percona, the company that delivers enterprise-class MySQL® and MongoDB® solutions and services, this week announced they are expanding their partnership to offer ClusterControl for Percona Server for MongoDB, enabling subscribers of Percona Support for MongoDB to access the advanced deployment, monitoring, management, and scaling solutions available from Severalnines. The combination of Percona Server for MongoDB and Severalnines ClusterControl enables organizations to cost-effectively deploy, monitor, manage and scale a NoSQL database infrastructure.

Percona has offered Severalnines ClusterControl for …

In November we held our first MySQL 5.8 planning session in London. On behalf of the MySQL team, I would like to thank you for your feature requests and suggestions. We reviewed over 150 pieces of feedback in total, and are looking forward to prioritizing a number of suggestions:

In MySQL 5.8, we are planning to make two important changes to modernize our code base.…