Mysql: slow alter?

Question

Mysql: slow alter?

2 Answers

Related questions

pwlnw · Answer 1 · 2019-03-24T00:55:28+0000

Once you have mastered the normal replication figure it out and then with replication master-master. Alternately on each server do ALTER. During operation ALTER direct the requests to another server.
\r
>2gb ram, Intel® Atom(TM) CPU D510 @ 1.66 GHz
>Server — martial, the simple is not.
\r
Not particularly hard to believe, by the way.

TheShock · Answer 2 · 2019-03-24T00:55:28+0000

CREATE TABLE new_name (new Layout); INSERT INTO new_name SELECT (column_list) FROM old_name; RENAME TABLE old_name TO to_delete_name, old_name TO new_name;

The point is that you can copy all the data into a new table. Negative – during that time it is better not to write new data, because they can not get a copy.

Mysql: slow alter?

Please log in or register to add a comment.

Please log in or register to answer this question.

2 Answers

Please log in or register to add a comment.

Please log in or register to add a comment.

Related questions

Most popular tags