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. 499 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

Thanks, Oracle for fixing MySQL Bug 69477

Just under a year ago, on June 14, 2013, I reported MySQL Bug 69477 (and MariaDB Bug MDEV-4662) titled “InnoDB: Use of large externally-stored fields makes crash recovery lose data”. 275 more words