I tried to drop one of the databases on the server. That locked the entire server up so I stopped the mysql process via the console.
I restarted the server, started mysql and now it seems hanged on:
debian-sys-maint | localhost | | Query | 192 | Opening tables | select count(*) into @discard from
Not necessarily hanged, but this takes a long time to move to a different query.
The other databases seem locked but I see no locks in "show open tables".
Any idea what's going on and what I could try?
Edit: it seems like the locks are moving from database to database and table to table. I guess it's doing some kind of checks?
Edit2: I think I understand what's happening, the answer to why it's doing this is: Linux Mint trigger slowly query on mysql on system booting