MySQL hangs when I query specific tables after truncate
See answer on StackExchange and the bug is known and related to the autoincrement.
And if you don't only want to understand the issue, but fix it, see https://dba.stackexchange.com/a/146181/220459.
mysqladmin -u root proc
mysqladmin -u root kill xxx

where xxx is the first process that is hanging.