Advanced MySQL configuration to import huge SQL files

Our nonprofit, WiderNet, provides off-line access to thousands of Web sites for people who lack Internet connectivity. (www.widernet.org ) Over 2,000 universities, schools, health care sites, and libraries in the developing world have adopted this solution, providing a bounty of educational information to millions of users.

We receive large SQL files (100GB+) that we need to import into our Windows-based MySQL server. It's a standalone server dedicated just to this process, with 24GB of RAM and a 2TB NVMe drive.

By addressing obvious hardware and software configuration issues, we've trimmed the import time from days to hours, but need someone with SIGNIFICANT MySQL server setup experience to advise us on our current configuration and suggest how we might improve the process.

We do not have control over how the files are dumped, so we need to everything in our power to speed things up.

More critically, once imported, we need to compress the tables to save space. They will be read-only in production.

Please, only bid if you have advanced experience with this rare environment. (Windows, MySQL, optimization...)