Tags » Innodb

MySQL table type and its peculiarities

Until recently, I did not really care what the ‘type’ the tables in my mysql db were – they could be InnoDB or MyISAM. But recently, I came across situations where I had to understand what the ‘type’ of the table is, to move forward. 223 more words

INNODB Backup and Recovery using mysqldump

InnoDB is a storage engine for MySQL. MySQL 5.5 and later use it by default. It provides the standard ACID-compliant transaction features, along with foreign key support (Declarative Referential Integrity). 210 more words

What are the different tables(Engine) present in MySQL, which one is default?

Following tables (Storage Engine) we can create :

1. MyISAM (Each MyISAM table is stored on disk in three files. The files have names that begin with the table name and have an extension to indicate the file type. 212 more words