I have a table with 500 rows of data in "MariaDB-10.3.1"
When I run TURNUCATE, ALTER, DROP, RENAME
operations take a long time for execution and nothing happens, I wait 30 minutes for 500 rows of data but not finished execution.
Anyone can help me to solve the problem?
I use
SELECT concat('KILL ', ID, ';') FROM INFORMATION_SCHEMA.PROCESSLIST WHERE `db` IN (DATABASE_NAMES);
and kill all process then my query worked.
Thank you all.