Another way to ALTER table on heavily loaded database
Posted by: Sergei Sergei
Date: April 20, 2016 12:28AM

Hello.
There is a big table with 2 billions records with very huge amount of queries (80% from all queries). Direct way to execute ALTER (add 1 column) isn't possible, of cource. I think about

insert into table_new ... select ... from table_old

but when i rename tables after, query cache will be dropped, and new uncached queries can hang database.
Does any other way to done alter?
Mysql 5.6.26, there is anorher database with master-master replication with origin.
Thanks.

Options: ReplyQuote


Subject
Written By
Posted
Another way to ALTER table on heavily loaded database
April 20, 2016 12:28AM


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.