GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Loading large tables with Unique Keys

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Loading large tables with Unique Keys

    This subject resurrects the trick shown in this thread for loading or altering large tables.

    Alter table performance with MyISAM

    I am struggling with some random cases where the REPAIR TABLE process is showing "Repair with keycache" instead of "Repair by sorting". In my latest test, on try # 2 it is "Repair by Sorting" which I believe is desired. Note that I use the "QUICK" option of the REPAIR TABLE command.

    What would cause this to go into "Repair with keycache"?

    Thanks,

    johndz

  • #2
    Unique indexes are always rebuilt with the key cache, not by sort.

    Comment

    Working...
    X