Answer the question
In order to leave comments, you need to log in
Why is an innodb based table being restored?
Hello.
There is an online store site on Bitrix, version 14.9.1
The site works on the locale on xampp, mysql 10.1.25-MariaDB
The site has the ability to order goods, that is, put goods in the basket.
And it was also found that the site accumulates abandoned carts and does not delete them.
Now there are 23,000,000 baskets that are not being used.
What exactly is the problem:
The b_sale_fuser table has the same 23,000,000 records.
I decided to clean them with Bitrix tools.
The purge works. Deleted a million records.
But when I reload xampp all 23,000,000 entries are
back in place.
Is this how the innodb database type works or am I messing around somewhere?
Answer the question
In order to leave comments, you need to log in
Somewhere you didn't see it. Are you sure mysql deleted the records?
TRUNCATE TABLE b_sale_fuser
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question