0

I try to execute the two following queries in MariaDB :

DELETE FROM `db_test`.`table1`;
DELETE FROM `db_test`.`table2`;

The problem is : deleting from the first table is ok (it takes a few seconds, nothing not usual), but deleting from the second table seems impossible. The query runs for a long time (more than 12 hours), then MariaDB crashes. The only solution here is to reinstall completely MariaDB, because MariaDB service won't launch anymore.

I think that's because table2 is very large, at the opposite of table1 :

  • table1 contains 135k lines, 18 MiB
  • table2 contains 6,2 millions of lines, 1,1 GiB

The same goes with TRUNCATE. The software I use is HeidiSQL.

Do you happen to know how to handle tables like this one ?

1 Answer 1

0

You can follow below steps, it may help you.

CREATE TABLE db_test.table2_tmp LIKE db_test.table2;

]RENAME TABLE db_test.table2 TO db_test.table2_to_be_deleted;

RENAME TABLE db_test.table2_tmp TO db_test.table2;

DROP TABLE db_test.table2_to_be_deleted;

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.