What is the difference between myisam and innodb

InnoDB is more reliable as it uses transactional logs for auto recovery. Ensure you are running MySQL 5.

Cloudflare Enterprise integration. Global audience reach with 28 data centers worldwide. Optimization with our built-in Application Performance Monitoring. Hand-picked related articles Knowledge Base. Knowledge Base. You can choose storage engine as per application need because both have some advantages and disadvantages.

Posted 5 years ago By Ajay Gupta Share. What is MySQLi? What does it do? MySQL query to copy data from one column to another column. How to upgrade MySQL 5. Integrate Facebook Login Authentication and Regist Get enum options values in laravel eloquent.

Laravel - How to use subquery in select statement? How to delete files if exists from public folder i Class form or html not found in Laravel 5. You can use more than one or any combination of these table types in your database.

Remember to asses the needs of your application before building it. With InnoDB you get transactions, speed and integrity three features not usually used in the same sentence. InnoDB has been designed for maximum performance when processing large data volumes. Its CPU efficiency is probably not matched by any other disk-based relational database engine.

InnoDB stores its tables and indexes in a tablespace, which may consist of several files or raw disk partitions.