MYSQL dump size variation

Asked Sep 05 '18 at 13:09

Active Sep 05 '18 at 14:33

Viewed 81 times

I have used AWS DMS for migrating 350 Gb of data.

After the migration, I can see that the size of databases in the source and target are not matching, that is there is variation in the size of DBs.

I have checked by taking mysqldump and found that there are variations in the DB size.

Did anybody faced the difference in DB size after the mysql dump?

edited Sep 05 '18 at 14:33

asked Sep 05 '18 at 13:09

Arun

please correct the english/grammer. – Aniruddh Parihar Sep 05 '18 at 13:15
can u check now – Arun Sep 05 '18 at 13:20
It's normal. table in the source and target have different size of unused space. Source can have space for deleted rows. Of course, deleted rows are not included in the dump. – DanB Sep 05 '18 at 14:33
Thank you @Daniel Blais for your reply – Arun Sep 05 '18 at 14:47

0 Answers0