Skip to content

Magento 2 Database optimization need help, database keep growing!

Magento 2 tables data is showing a total size “5,115,687” , I want to truncate some large tables please guide me can I truncate the following tables without affecting store functionality:
enter image description here

  1. quote
  2. quote_address
  3. quote_address_item
  4. quote_id_mask
  5. quote_item
  6. quote_item_option
  7. quote_payment
  8. qoute_shipping_rate
    enter image description here

because these tables keep growing and our website is slow
please guide me can I truncate these tables if yes then how? thanks