innodb is acid engine

what are the main differences between MyISAM and InnoDB
table storage structures ?
what are the advantages and disadvantages in usage of these ?

Question Posted / dharma teja

Answer Posted / dharma teja

Is This Answer Correct ?

15 Yes

3 No

Please Help Members By Posting Answers For Below Questions

write a query to mysql in safe mode and to change the root password

928

how to dump all databases for backup. Backup file is sql commands to recreate all db's.

881

How many columns can be used for creating Index?

997

Where is mysql data stored?

845

Which statement is used in a select query for partial matching?

1156

Can you shard mysql?

892

What is procedure in mysql?

897

How do I export mysql query results to excel?

930

How to dump a table to a file with 'mysqldump'?

978

What are the other commands to know the structure of a table using mysql commands except explain command?

972

How do I switch users in mysql?

926

How do I tune a mysql query?

842

Why mysql is used with php?

935

Can we rename database in mysql?

907

Is mysql query case sensitive?

921