Tags » Innodb

What is difference between MYISAM and InnoDB?

 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


Starting MySQL. ERROR! The server quit without updating PID file

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


Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

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

How to Define Full-Text Index and Use Full-Text Search

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

Database Developer

Introduction to MySQL Full-Text Search

Full-Text Search is MySQL build in functionality which allows the user to search a given text very efficiently across single or multiple tables. MySQL 5.6.4 supports full-text indexes with MyISAM and InnoDB tables. 200 more words

Database Developer