Interested to Buy Any Domain ? << Click Here >> for more details...
what are the main differences between MyISAM and InnoDB
table storage structures ?
what are the advantages and disadvantages in usage of these ?
- 10 Answers
- 43769 Views
- E2 Solutions, Tesco, I also Faced
- E-Mail Answers
Answer Posted / narendra sharma
MyISAM : it is an engine and faster and occupy the less
space so not good enough for large transaction, also not
support the foreign key concept, it provide the table level
locking mean any change in the will be available as modified
table next time.
innoDB : It is also an engine and slow in comparison the
MyISAM engine, but good enough for large transaction, also
provide the row level locking mean updation is fast. Useful
for BANK SYSTEM.
| Is This Answer Correct ? | 17 Yes | 1 No |
Post New Answer View All Answers
What is dirty read and phantom read?
What is the difference between mysql_connect and mysqli_connect?
How to get current MySQL version?
Is mysql written in c?
What is new mysqli?
How we can create index in mysql?
what are the different tables present in mysql? : Mysql dba
What is the query to display top 20 rows?
How do I import database through command line?
What is data node in mysql cluster?
Does mysql need a server?
Where is the mysql database stored?
How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.
What is mysql database server?
Which storage engine is best in mysql?
