Our nonprofit, WiderNet, provides off-line access to thousands of Web sites for people who lack Internet connectivity. ([login to view URL]) 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.
13 фрілансерів(-и) у середньому готові виконати цю роботу за $142
Hello Hope you are doing well. I have 7 years of experience in Windows and Mysql Server Management. I can tune mysql to achieve good import speed
I'll do Advanced MySQL configuration to import huge SQL files as per your requirements and with full satisfaction In order to any delay we'll refund your money.