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?

  • 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 '19 at 0:43

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.