MySQL :: Re: Instant DDL on ADD Column puts queries in opening tables state

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Re: Instant DDL on ADD Column puts queries in opening tables state

Posted by: Peter Brawley
Date: February 02, 2022 10:14AM

Did you try growing table_open_cache?

What does Shoe Engine InnoDb Status say during the Add Column process?

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

Instant DDL on ADD Column puts queries in opening tables state

Sunny Nagra

February 02, 2022 09:32AM

Re: Instant DDL on ADD Column puts queries in opening tables state

Peter Brawley

February 02, 2022 10:14AM

Re: Instant DDL on ADD Column puts queries in opening tables state

Sunny Nagra

February 02, 2022 10:20AM

Re: Instant DDL on ADD Column puts queries in opening tables state

Peter Brawley

February 02, 2022 11:05AM

Re: Instant DDL on ADD Column puts queries in opening tables state

Sunny Nagra

February 02, 2022 12:45PM

Re: Instant DDL on ADD Column puts queries in opening tables state

Peter Brawley

February 02, 2022 03:59PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.