Shulou(Shulou.com)06/01 Report--

Earlier, Mr. Han Feng wrote an article about viewing the MySQL implementation plan, which explained a script, which was a good feature he had customized earlier.

How to use a gadget to greatly speed up MySQL SQL statement optimization (with source code)

The details of the use are introduced in more detail in the article.

Has been a collection of articles, but no practice, today in the local environment under the debugging, the overall feeling is good. It is necessary to use Python to customize some content and output reports, and Python does have a unique advantage.

As to the output of the execution plan, as explained at the beginning of the article, there are actually a lot of knowledge points. MySQL's execution plan looks simpler than Oracle, but if you want to make an in-depth analysis, the content and output need to be carefully pondered. On the whole, the readability is not as clear as Oracle.

I'll see if I want to change some content, customize and improve something later on this basis.

= BASIC INFORMATION =

+-+

| | server_ip | user_name | db_name | db_version | |

+-+

| | 127.0.0.1 | test_user | mysql | 5.7.19-log | |

+-+

= ORIGINAL SQL TEXT =

SELECT count (*)

FROM test2

I also have a general idea for the part of MHA, and I will spend some energy trying to customize it later. Today, the whole process of MHA is connected together, and I find that there is still a sense of accomplishment.

Keep writing the code.

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.