DB : Table negotiable_quote use 2.894 GB space

[Nolwennig-Jeulin]

Hi,

In ou production database, we found that the negotiable_quote table takes up a significant amount of space, almost 3 GB.

MariaDB [information_schema]> SELECT TABLE_NAME AS `Table`,
-> ((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024 / 1024) AS `Size (GB)`
-> FROM information_schema.TABLES
-> WHERE TABLE_SCHEMA = "###"
-> ORDER BY (DATA_LENGTH + INDEX_LENGTH) DESC limit 1;
+------------------+----------------+
|      Table       |    Size (GB)   |
+------------------+----------------+
| negotiable_quote | 2.894226074219 |
+------------------+----------------+
1 row in set (0.007 sec)

How can we practically free up space?

---

• Maybe a architecture refactoring should be implemented to permit to delete older negotiable quote?
• Does GDPR compliance require these kinds of features?