Good afternoon. Never did scan the database from dumps, but came need. The size of the dump - 40 GB, after the sweep should be 200GB. You need to deploy it on the laptop to optimize it. But faced with too long a scan, for 14 hours only 1.3 GB(pace scan will go months...).
Deployed through the console using the code:
SET NAMES utf8; DROP DATABASE `tecdoc`; CREATE DATABASE `tecdoc` DEFAULT CHARACTER SET utf8; USE `tecdoc`; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET autocommit=0; SET foreign_key_checks=0; SET unique_checks=0; SOURCE path/file_name.sql; COMMIT; SET autocommit=1; SET foreign_key_checks=1; SET unique_checks=1;
Can anyone suggest how to speed up the scan?(at least up to 3 days, the AMD FX-9830P, 3000-3700 MHz
RAM 16GB, DDR4-2400).