MySQL

Full Text Searching in Innodb Engine

This is the time when we can start using full text searching in Innodb. InnoDB Fulltext Searching is greatly enhanced the transactional storage engine, which is completely different from MyISAM. So this is the new change in storage world which can be the revolution in storage.

MySQL root Password Recovery

Most of the people ask me this question how to recover the MySQL root password? So there is a possible way to recover the MySQL root password. By running MySQL in non-privileged environment only the risk is involved that we need to restart the MySQL server which can be difficult in live environment databases. Follow [...]

InnoDb becomes default storage engine in MySQL 5.5

MySQL 5.5 beta is released. This version contains a lot of enhancements focusing on performance, reliability and scalability. MySQL team have been focusing on InnodDB engine for a long time, so starting from 5.5 InnoDB will be the default storage engine. This marks the end of MyISAM being the default engine. This version will include [...]