Tag Info

New answers tagged

0

Change the ft_min_word_len value to specify the minimum length of the word to be included in a MyISAM FULLTEXT index. ft_min_word_len The minimum length (default: 4) of the word to be included in a MyISAM FULLTEXT index. Note: FULLTEXT indexes on MyISAM tables must be rebuilt after changing this variable. Use REPAIR TABLE tbl_name QUICK. ...


1

I am not sure when but sooner or later we're going to see deprecation of MyISAM. InnoDB is performing well and it does have fulltext as well (though performance is a bit of something being worked over there.) InnoDB is even a default storage engine in latest MySQL versions. If you really really need performance from FULLTEXT go with MyISAM (Note ...


3

If you want a proper database then of the two you should go for innodb - it supports ACID transactions, referential integrity, and smaller granularity locking. myISAM is faster in a number of read-only use cases but: The lack of support for transaction safety can lead to corruption in multi-user situations where several updates happen at the same time ...


1

Not sure if the issue is resolved. But as suggested here're some ways you can do this : 1. ALTER TABLE Approach : ALTER TABLE ENGINE=INNODB; Considerations for this approach : As you mentioned you have a big table this command will take time to execute. CREATE TABLE and INSERT INTO Approach : You can create a empty table with INNODB storage engine and ...


1

I have an MyISAM2InnoDB blog that covers your question thoroughly. It discusses index differences, especially PRIMARY KEY and FULLTEXT, space (2x-3x is typical), LOCK TABLES, decreasing key_buffer_size and increasing innodb_buffer_pool_size (very important), etc.


3

InnoDB tables tend to occupy more space than MyISAM tables do. While converting, new physical files are being created, so you have to have free space on the disk (Hard to estimate, but to be safe I would say 120G) If you use Percona tools to make the change online, all modifications on the original table will be stored in a temporary table using triggers. ...



Top 50 recent answers are included