Another way to ALTER table on heavily loaded database
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.
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.