what is the main difference between myisam and innodb
Answer Posted / ranganath
Other differences are :
1. innodb requires more RAM than mysiam
2. myisam relies on OS for caching while innodb caches with
in the engine itself.
3. Most preffered is innodb because
- Transaction safe
-It has commit, rollback, and crash recovery capabailities
- Innodb is designed for maximum performance when processing
large volumes of data.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what is cte? : Mysql dba
In which language mysql has been written?
What is the default port for MySQL Server?
What are the different data types in mysql?
Why mysql is used with php?
How to create and drop view in mysql?
How does mysql store data?
What is the difference between having and where clause in mysql? Explain
Does insert statement lock the table?
Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.
Why does mysql have so many connections?
How to check if a record exists in a mysql database php?
Is mysql still popular?
How to calculate the difference between two time values?