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

This article mainly introduces the brief analysis of mysql termination sql sentence, hoping to supplement and update some knowledge, if you have other questions to understand, you can continue to follow my updated article in the industry information.

How does mysql terminate the currently executing SQL statement? The following is to introduce its implementation.

Procedure:

Show processlist

Find out the sentence you want to stop.

Then find out the id of the statement you want to terminate

ID to be killed by mysqladmin-uroot-ppassword kill under the system

The process of executing a MySQL query statement:

1. The client sends a query to the CVM

two。 The server first checks the query cache and immediately returns the results stored in the cache if it hits the cache. Or move on to the next stage.

3. The server performs SQL parsing and preprocessing, and then the optimizer generates the corresponding execution plan.

According to the execution plan generated by the optimizer, 4.MySQL calls the API of the storage engine to execute the query.

5. Return the result to the client.

These are the details of the brief analysis of the mysql termination sql sentence, please pay more attention to other related articles!

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.