Possible Duplicate:
What is InnoDB and MyISAM in MySQL?
in my project database some of table has engine type innoDB and some others Myisam. why it was set like this ?
The 2 major types of table storage engines for MySQL databases are InnoDB and MyISAM. To summarize the differences of features and performance,
In light of these differences, InnoDB and MyISAM have their unique advantages and disadvantages against each other. They each are more suitable in some scenarios than the other.
Advantages of InnoDB
Disadvantages of InnoDB
Advantages of MyISAM
Disadvantages of MyISAM
The comparison is pretty straightforward. InnoDB is more suitable for data critical situations that require frequent inserts and updates. MyISAM, on the other hand, performs better with applications that don’t quite depend on the data integrity and mostly just select and display the data.
Reference: Comparison InnoDB and MyISAM
You can also check it out here for further details: MyISAM Or InnoDB MySQL engine?
Hope this helps.
When you use a MySQL database you can select the storage engine that fits your needs. From what you have said it sounds like you have inherited this project, so the previous developer probably selected different engines when creating tables. They could have also used 3rd party tools and MySQL Workbench with different settings that caused the tables to be created with different storage engines.
Anyway, a quick Google search or a search on this site should give you information as to the differences between the two, as well as their advantages and disadvantages (essentially, table vs. row -level locking, relationship enforcement, transactions and rollback).
Moving forward you can set the default storage engine in your configuration file so that when you create new tables they will be of the same type.
InnoDB is the default engine for MySQL 5.5.
Here is a good conversation to get you started: MyISAM versus InnoDB
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With