1

In my database contains 3 millions records. Initially haven't any FULLTEXT index in my database. Now I'm trying to add FULLTEXT index using Create index statement, that take huge time and browser showing connecting and ram goes to 70%. I feel that nothing happen to database. what should I follow? Is there any other way to add FULLTEXT index? If I'm add FULLTEXT index is that affect to next inserting values? 1st I want to anyhow add FULLTEXT index to my table. I'm using Xammp MySql database.

Maduri
  • 249
  • 1
  • 5
  • 19

1 Answers1

2

1.Create the dummy table like your original table structure.
2.create indexes on your dummy table which want you.
3.take a dump from your original table and import to dummy.
4.drop the original table and rename the dummy table to original name.

  • I tried previous way. Suddenly my sql server restarted. Now I'm not sure weather FULLTEXT index happened or not. How I check it? (Weather fulltext index added or not) – Maduri Dec 01 '14 at 04:29
  • 1
    @Maduri,`show index from table_name;`,please care for your databackup –  Dec 01 '14 at 04:34
  • :) .Thanx lot dear. That showing FULLTEXT index is in my column.(What's meaning of "Cardinality 1". 1 mean is that only affected to one record? )I think that affected :). One thing to have ask. When I'm inserting records again and again should I run the FULLTEXT index adding code or is that affect every record after one time create? – Maduri Dec 01 '14 at 04:40
  • Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment corpus 1 Cor_Sentence(column name) 1 Cor_Sentence(column name) NULL 1 NULL NULL FULLTEXT – Maduri Dec 01 '14 at 04:44
  • 1
    @Maduri,http://stackoverflow.com/questions/2566211/what-is-cardinality-in-mysql please refer this –  Dec 01 '14 at 04:52
  • Thanx dear. I got the point. One thing, do I need to again run FULLTEXT adding code when I inserting record again and again? – Maduri Dec 01 '14 at 04:58
  • Thanx lot dear. Have a nice day :). – Maduri Dec 01 '14 at 05:04