Shulou(Shulou.com)05/31 Report--

This article mainly shows you "how to use Percona-toolkit tools in MySQL", the content is easy to understand, clear, hope to help you solve doubts, the following let the editor lead you to study and learn "how to use Percona-toolkit tools in MySQL" this article.

Maatkit and Aspersa

If you have heard of it, you may reveal your age. If you check Aspersa-related articles now, you will find that download links and the like are not available.

I first saw this order in an article written by Chu Ba in 2011. I was a little excited when I first saw it. I was surprised that there was such a concise order. One command does the job of at least 10 commands.

But I immediately fell into a panic, because to my surprise, there seemed to be no relevant explanations and documents on the Internet. When I saw a series of commands from these tools, it dawned on me. It turns out to be the pt tool we are using.

Maatkit and Aspersa are both from the same author, Baron Schwartz. Look, Twitter is now the CEO of another company.

Of course, it can be clearly seen in the command interpretation of the pt tool that several co-authors are Daniel Nichter,Frank Cizmich.

Let's take a look at some simple categories of pt tools

Maatkit tools focus more on the database level, starting with the genes of perl.

The category of Aspersa tends to be at the system level, such as disk information.

If you are sharp-eyed, you will find that the protocols used by the two open source tools are different, one is GPL, the other is BSD, after the integration begins with pt, they uniformly use GPL. The differences between GPL and BSD can be seen in the figure below, shared by teacher Ruan Yifeng.

So the simple details show that there is a short story about the development of pt tools. Such a tool can almost be said to be the first necessary tool for DBA. The development and update in recent years is still very frequent, and a small version is launched almost every 3 months or so.

The 3.0 era entered in 2017, so the version used online is almost always 2.2 (since 2013), which has spanned several years.

The pt tool is acquired by Percona and has a special project to maintain.

So this can also indirectly see a development process of many open source projects, pt tools have a beginning and an end. It is not easy to pass on smoothly.

The above is all the content of this article entitled "how to use Percona-toolkit tools in MySQL". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.