How to install and use percona-toolkit

This article mainly explains "how to install and use percona-toolkit". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn how to install and use percona-toolkit.

Log in to https://www.percona.com/software/database-tools/ to download

Tar-zxvf percona-toolkit-2.2.20.tar.gz

Cd percona-toolkit-2.2.20

Perl Makefile.PL

Make

Make install

Use pt-online-schema-change to modify the storage engine.

[root@linfytest6 bin] # / usr/local/bin/pt-online-schema-change-- alter "ENGINE=InnoDB" Dumblinfygramt T1-uroot-p111111-S / tmp/mysql3306.sock

-zxvf

Percona-toolkit-2.2.6.tar.gz

Tar-zxvf percona-toolkit-2.2.6.tar.gz

Thank you for reading, the above is the content of "how to install and use percona-toolkit", after the study of this article, I believe you have a deeper understanding of how to install and use percona-toolkit, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!