Sometimes but not always
truncate table statements get stuck in
checking permissions state for several minutes (up to 7-8 minutes).
I'm running MySQL 8.0.12 (for Linux on x86_64 (MySQL Community Server - GPL)) My tables are partitioned with around 365 partitions in each.
There are only 5 users (excluding root and mysql.). The 5 users are not tied to a specific host. Sometimes the same users is used from multiple hosts at same time.
Is this a known problem? What are the possible causes or solutions?
Any help is much appreciated!