Announcement

Announcement Module
Collapse
No announcement yet.

Creating index in large table

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

  • Creating index in large table

    Hi,

    1) I have table that contains 16 million records (16,186,288 ; MyISAM ; latin1_swedish_ci ; 2.8 GiB ), and i need to:
    1. delete one index and create an index on other column

    Any ideas how long it can take...



    2)I need to backup 43GB database. What is the best way to do it? Any scripts or tools. The database is all time alive. There are about 2 inserts per second.
Working...
X