Faster mysql imports

#Innodb before import:
SET FOREIGN_KEY_CHECKS = 0;
SET UNIQUE_CHECKS = 0;
SET AUTOCOMMIT = 0;
#After import:
SET UNIQUE_CHECKS = 1;
SET FOREIGN_KEY_CHECKS = 1;
COMMIT;

Source: support.tigertech.net

Faster mysql imports

#To disable MySQL indexes:
ALTER TABLE `table_name` DISABLE KEYS;
#To enable MySQL indexes:
ALTER TABLE `table_name` ENABLE KEYS;

Source: support.tigertech.net

Similar codes

1 vote210 views1 answer
Oracle explain plan
SQL
0 vote222 views1 answer
Coalesce for comma separated in sql server
SQL
3 votes234 views1 answer
Async await mysql nodejs
SQL
0 vote229 views1 answer
PSQL use LIKE with timestamps
SQL
-1 vote219 views1 answer
Add column alter table default value
SQL
0 vote242 views1 answer
Drop a view in sqlite
SQL
7 votes204 views2 answers
Create index mysql
SQL
0 vote218 views1 answer
Mysql identified by syntax error
SQL
4 votes238 views3 answers
Sql drop database if exists
SQL
0 vote425 views1 answer
Power bi connect to postgresql
SQL