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

Why are mysql queries locked? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

Mysql query why there is a lock

Deadlock is a phenomenon of mutual waiting caused by the competition for resources in the process of execution. If there is no external force, they will not be able to advance.

Solution method

1. Increase the maximum number of connections allowed

Set global max_connections=4000

two。 Kill the process with KILL + threads

KILL 420821

MySQL is a relational database management system developed by the Swedish company MySQL AB and belongs to the products of Oracle. MySQL is one of the most popular relational database management systems. In the aspect of WEB application, MySQL is one of the best RDBMS (Relational Database Management System) application software. MySQL is a relational database management system in which relational databases store data in different tables instead of all data in one large warehouse, which increases speed and flexibility.

The answer to the question about why there is a lock in the mysql query is shared here. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

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.