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 ?