6

I have a table(innodb) with about 50 million rows, tries to drop it, then it hangs, I checked process list:
checking permission

what is checking permissions state and why does drop table needs it?

Improve this question
2
  • Similar situation, it takes 13 minutes to check permissions on DROP. It's a bug, whatever it is doing it has nothing to do with permissions.
    – John
    Mar 11, 2019 at 0:43
  • @John I can confirm: I have exactly 34 rows in my mysql.user table, and a DROP TABLE has been running for the last 12 minutes. It completed while I was writing this comment.
    – LSerni
    Oct 4, 2022 at 14:58

1 Answer 1

Reset to default
2

According to http://dev.mysql.com/doc/refman/5.0/en/general-thread-states.html, the state "Checking Permissions" is defined as follows:

•checking permissions
The thread is checking whether the server has the required privileges to execute the statement.

I found something concerning Slow Checking Permissions in forums.mysql.com The thread of responses in this forum entry suggests reducing the number of user entries in mysql.user.

IMHO, the "Checking Permissions" issues is a hard one to fathom even for experts.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .