How to disable index in innodb

by

Have you tried the following?

    SET autocommit=0; 
    SET unique_checks=0; 
    SET foreign_key_checks=0;

From the MySQL References https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-bulk-data-loading.html

See Section “Bulk Data Loading Tips“

More Related Contents:

  1. Is there any performance gain in indexing a boolean field?
  2. MySQL Integer vs DateTime index
  3. How to debug Lock wait timeout exceeded on MySQL?
  4. How do I add indexes to MySQL tables?
  5. 1114 (HY000): The table is full
  6. How to shrink/purge ibdata1 file in MySQL
  7. Mysql::Error: Specified key was too long; max key length is 1000 bytes
  8. How to see indexes for a database or table in MySQL?
  9. How to convert all tables from MyISAM into InnoDB?
  10. Speeding up row counting in MySQL
  11. UUID performance in MySQL?
  12. MySQL varchar index length
  13. MySQL InnoDB foreign key between different databases
  14. Mysql Improve Search Performance with wildcards (%%)
  15. Force InnoDB to recheck foreign keys on a table/tables?
  16. How can I manipulate MySQL fulltext search relevance to make one field more ‘valuable’ than another?
  17. What is MySQL’s default ON DELETE behavior?
  18. How do I repair an InnoDB table?
  19. How to enable INNODB in mysql
  20. How can I check MySQL engine type for a specific table?
  21. Does Order of Fields of Multi-Column Index in MySQL Matter
  22. Create an index on a huge MySQL production table without table locking
  23. MySQL InnoDB: autoincrement non-primary key
  24. How do I rename a MySQL database (change schema name)?
  25. How to regex in a MySQL query
  26. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  27. MySQL optimizing INSERT speed being slowed down because of indices
  28. MySQL DROP all tables, ignoring foreign keys
  29. Mysql performance on 6 million row table
  30. How can I rebuild indexes and update stats in MySQL innoDB?

Leave a Comment