R
R
Roman Mirilaczvili2019-10-23 16:25:57
MySQL
Roman Mirilaczvili, 2019-10-23 16:25:57

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

2 answer(s)
L
Lazy @BojackHorseman MySQL, 2019-10-23
@2ord

the difference will be only in a box of the table-receiver. insert-select will lock it before the query is executed

I
Ivan Shumov, 2019-10-23
@inoise

Why did you import AWS Database Migration Service?)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question