Как в разы уменьшить размер базы данных Magento 2 после длительной эксплуатации магазина

Сопровождение
, ,
1

Способ аналогичен Magento 1.x:

SET FOREIGN_KEY_CHECKS=0;
TRUNCATE log_url;
TRUNCATE log_url_info;
TRUNCATE log_visitor;
TRUNCATE log_visitor_info;
TRUNCATE report_event;
TRUNCATE report_viewed_product_index;
TRUNCATE report_compared_product_index;
TRUNCATE report_viewed_product_aggregated_daily;
SET FOREIGN_KEY_CHECKS=1;
DELETE FROM session; OPTIMIZE TABLE session;
2

Таблицы log_* перестали использоваться в Magento 2.
Новый скрипт:

SET FOREIGN_KEY_CHECKS=0;
TRUNCATE cron_schedule;
TRUNCATE report_event;
TRUNCATE report_viewed_product_index;
TRUNCATE report_compared_product_index;
TRUNCATE report_viewed_product_aggregated_daily;
SET FOREIGN_KEY_CHECKS=1;
DELETE FROM session; OPTIMIZE TABLE session;
3

Ещё может очень расти таблица customer_visitor. Новая версия скрипта:

SET FOREIGN_KEY_CHECKS=0;
TRUNCATE cron_schedule;
TRUNCATE customer_log;
TRUNCATE customer_visitor;
TRUNCATE report_event;
TRUNCATE report_viewed_product_index;
TRUNCATE report_compared_product_index;
TRUNCATE report_viewed_product_aggregated_daily;
SET FOREIGN_KEY_CHECKS=1;

Чтобы таблица customer_visitor больше не росла, установите модуль yireo/magento2-disablelog2.

4 
SET FOREIGN_KEY_CHECKS=0;
TRUNCATE cron_schedule;
TRUNCATE customer_log;
TRUNCATE customer_visitor;
TRUNCATE report_compared_product_index;
TRUNCATE report_event;
TRUNCATE report_viewed_product_aggregated_daily;
TRUNCATE report_viewed_product_aggregated_monthly;
TRUNCATE report_viewed_product_aggregated_yearly;
TRUNCATE report_viewed_product_index;
SET FOREIGN_KEY_CHECKS=1;
DELETE FROM session; OPTIMIZE TABLE session;