Answer the question
In order to leave comments, you need to log in
How to properly import an InnoDB table of 14M+ rows into a similar table with compression?
The DBMS is hosted on Amazon RDS. The original table is 18.7 GB. The target table was created with additional options ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1
.
Is it correct to import so much data with a query like this:
Or do I need to do an export/import with mysqldump? INSERT INTO new_tbl SELECT * FROM old_tbl;
Answer the question
In order to leave comments, you need to log in
the difference will be only in a box of the table-receiver. insert-select will lock it before the query is executed
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question