Large MySQL import stuck at "Waiting for table flush"
I have always found large mysqldumps to be problematic. The best tactic I know is to reduce the size of the import. aka split the database dump into many dumps that let you run a per table restore this will let you make tangible progress and reduce the size and time each import takes.
https://github.com/kedarvj/mysqldumpsplitter