Shulou(Shulou.com)06/01 Report--

This article mainly introduces "MySQL source import is very slow how to solve", in the daily operation, I believe that many people have doubts about how to solve the problem when MySQL source import is very slow. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubts of "MySQL source import is very slow how to solve"! Next, please follow the editor to study!

Now there is such a demand, the intranet has a database service, and the database of the extranet needs to be imported into the intranet database.

The database of the external network is exported to the sql file has 700MB, and it is very slow to import with the source that comes with MySQL, so the following methods are used to accelerate the import, and the test is very fast.

1. Log in to MySQL

Enter the intranet server, log in to mysql, and enter the password.

Mysql-u root-p2. Create a database

Create a database according to the requirements

Create database database name; 3. Set parameters

Sql_log_bin closes the binary log

Autocommit turns off transaction auto-commit

Set sql_log_bin=off;set autocommit=0;4. Use database use database name; 5. Open the transaction start transaction;6. Import the sqlsource file. SQL; 7. Manually commit the transaction commit;8. Change back to the configuration set sql_log_bin=on;set autocommit=1; with mysql to accelerate source import data # into mysql to execute your sql statement 1mi-your sql statement 2mo-your sql statement 3SET GLOBAL foreign_key_checks=1;SET GLOBAL unique_checks=1;SET GLOBAL innodb_flush_log_at_trx_commit=1;SET GLOBAL sync_binlog=1 At this point, the study on "how to solve the problem of MySQL source import is very slow" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.