MySQL Forums
Forum List  »  Newbie

Log how long a import takes
Posted by: Rod Rayner
Date: November 08, 2018 10:44AM


We need to run a test import before doing things in our live environment but need to know how long the import takes.

The file 10Gb at Max compression, when uncompressed its around 170 Gb. In the past when we have run tests it has taken around 9 hours which is too long to sit in front of a PC and watch :-)

Is there a way to log how long the import takes / when it finished.

I am aware of "show table status;" but we are unsure what the last table is called so this kind of doesn't help.

Thanks in advance.

Options: ReplyQuote

Written By
Log how long a import takes
November 08, 2018 10:44AM
November 08, 2018 12:15PM

Sorry, only registered users may post in this forum.

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.