MySQL Forums
Forum List  »  InnoDB

taking long time to ALTER the table
Posted by: Ra Nala
Date: April 07, 2016 07:47AM

Hi,

I am using MySQL 5.7 version (InnoDB). In one of my table, data having nearly 4200000 and if i want add columns then it is taking long time to ALTER the table.

Kindly tell me what is the best approach to reduce the time.

Thanks,
Ra na la

Options: ReplyQuote


Subject
Views
Written By
Posted
taking long time to ALTER the table
1801
April 07, 2016 07:47AM
1047
April 13, 2016 03:08AM
1028
April 14, 2016 12:23AM


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.