Setup upgrade works more than 15 minutes during installing module

[ihor-sviziev]

Issue Description

Preconditions

1. Magento CE 2.2.6 with ~1 million of existing orders + the ~2 millions of quotes in quotes table
2. mc-magento2 1.0.30

Steps to reproduce

1. Install module
2. run `php bin/magento setup:upgrade`

Actual and Expected result

Setup upgrade process should run just few minutes

Additional information

This issue appears because during installing module execution altering tables of "quote", "sales_order" and "sales_order_grid" tables, as result - it takes more than 5 minutes just to execute one alter table command.

How it can be avoided - do not add any columns to orders and quotes tables, instead - use own tables and select data from them when needed.

[gonzaloebiz]

Thanks

[onepack]

This is not fixed. After install the whole site is not responding for a long time and I also see the quote and order table altered by the MC module! mailchimp_abandonedcart_flag, mailchimp_campaign_id, mailchimp_flag and mailchimp_landing_page are added.

[onepack]

@ihor-sviziev, can it be you installed via composer? There is a general bug that updating via composer can disable all cache types. This will make the shop malfunction. After using composer I nowadays always check the cache:status. This was my problem in this case after installing mailchimp.

[ihor-sviziev]

Hi @onepack, You just descrived two issues - issue that mailchimp module updating quite big tables - orders and quotes that causes long downtime, this is what should be fixed in mailchimp module. Second issue - following https://github.com/magento/magento2/issues/17634, it’s magento issue and it have to be fixed separately