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 vote142 views1 answer
Can pandas fetch data from sql
SQL
6 votes192 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
2 votes137 views1 answer
Drop table if exists in postgres
SQL
1 vote153 views1 answer
Psql view enum values
SQL
8 votes131 views1 answer
Alter tablespace add datafile
SQL
1 vote149 views1 answer
Sysdate in sql
SQL
1 vote141 views1 answer
Psql human readable
SQL
2 votes159 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
5 votes144 views3 answers
Truncate function in sql oracle
SQL
-1 vote139 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL