Search code examples
mysqldatabasemariadb

MariaDB take long time to execute

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?

Solution

  • 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.