var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Disable index/keys for innodb table
I have large table ( ~ million records) in which I am doing large table inserts/ deletes at a time approx 10,000 records inserted/deleted at a time. the table has several fields that are indexed.
There are few articles on disabling the index/key when doing such updates for efficiency and optimization purposes however they all refer to tables with the myIsam engine type.
Does an InnoDB table support disable index/keys? Is there any other way to speed up insert/ deletes on such a large table with indexes and to recreate those indexes?