am writing this article to all those PHP follower to understand the difference between MYISAM and INNODB.
1. MYISAM supports Table-level Locking
2. MyISAM designed for need of speed… 100 more words
Tags » Innodb
Issue: I got this error while restarting mysql service
You just needs to add the below line in /etc/my.cnf
innodb_force_recovery = 1
Please restart mysql now. 24 more words
I got the below error while restarting mysql service after updating the my.cnf file :
Plugin ‘InnoDB’ init function returned error. Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed. 59 more words
FULLTEXT index can be added while creating a new table or by altering an existing table.
Adding full-text index while creating new table:
Full text-index can be defined while creating a table. 485 more words