What should I do if mysql cannot delete the table?

Mysql cannot delete the table solution: 1. Query the process through the "SHOW FULL PROCESSLIST;" command; 2. Find the corresponding table, and then delete the table by executing the "kill 5;" command.

The operating environment of this tutorial: Windows 10 system, mysql5.5 version, Dell G3 computer.

What should I do if mysql cannot delete the table?

Solution to the problem that the MySQL table cannot be opened or deleted:

The amount of data in a database is too large, many people are operating this database, and there is a large table plus index computer card After it died, the table could not be opened or deleted because there were other businesses and MySQL could not be restarted

SHOW FULL PROCESSLIST; //查询进程

Using the above sql statement to query all processes, it was found that one of the columns had a state of Locked (by other queries) Lock)

Find the corresponding table and kill (the queried Id)

kill 5;

problem solved!

Related introduction:

MySQL is a relational database management system developed by the Swedish MySQL AB company and is a product of Oracle. MySQL is one of the most popular relational database management systems. In terms of WEB applications, MySQL is one of the best RDBMS (Relational Database Management System) application software.

MySQL is a relational database management system. A relational database stores data in different tables instead of placing all data in one large warehouse, which increases speed and flexibility.

The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts a dual licensing policy and is divided into community version and commercial version. Due to its small size, fast speed, low total cost of ownership, and especially the characteristics of open source, MySQL is generally chosen as the website for the development of small, medium and large websites. database.

Recommended learning: "MySQL Video Tutorial"

The above is the detailed content of What should I do if mysql cannot delete the table?. For more information, please follow other related articles on the PHP Chinese website!