Locked Mysql table

Asked

Viewed 1,127 times

0

When trying to consult the table via phpmyadmin there is no return and gets locked. Not even trying to do a query with php it’s return.

Any suggestions to resolve?

mysql

  • Tries REPAIR TABLE sua_tabela

  • He’s not answering either, just waiting for the requisition and nothing.

  • Does this table have many records? It could be index problems.

  • Ah, something around 70000, but the worst is that I can’t delete it or the database. As if I’ve been running some process yet.

  • Index problem? - Could be... Try then OPTIMIZE TABLE sua_tabela

  • Well, locked table can be solved with Restart without XAMP or WAMP. In more extreme cases, I restarted the computer and try again. Also analyze the content of this table

  • Try using Mysql Workbench or the console, this might be a problem for your phpmysql drive.

Show 2 more comments

1 answer

2

use show full processlist; to see the process that is locking the table then use kill [id_do_processo]

Browser other questions tagged mysql

You are not signed in. Login or sign up in order to post.