Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Reduce the database size #13

Open
dmitrii-fediuk opened this issue Feb 8, 2020 · 1 comment
Open

Reduce the database size #13

dmitrii-fediuk opened this issue Feb 8, 2020 · 1 comment

Comments

@dmitrii-fediuk
Copy link
Contributor

No description provided.

@dmitrii-fediuk
Copy link
Contributor Author

dmitrii-fediuk commented Feb 8, 2020

SET FOREIGN_KEY_CHECKS=0;
TRUNCATE report_event;
TRUNCATE report_viewed_product_index;
TRUNCATE report_compared_product_index;
TRUNCATE report_viewed_product_aggregated_daily;
TRUNCATE customer_visitor;
SET FOREIGN_KEY_CHECKS=1;
composer require yireo/magento2-disablelog2:*

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant