Login
Register
All Activity
Questions
Unanswered
Tags
Users
Ask a Question
About Us
986
Questions
785
Answers
Interview Preparation mode
beta
Funny Facebook Status
Enter your email address
All categories
SQL Server Interview Questions and Answers
(197)
SSIS Interview Questions and Answers
(54)
SSRS Interview Questions and Answers
(9)
SSAS Interview Questions and Answers
(29)
.NET Interview Questions and Answers
(186)
Oracle Interview Questions and Answers
(122)
Java Interview Questions and Answers
(32)
UNIX Interview Questions and Answers
(47)
Networking Interview Questions and Answers
(17)
MySQL Interview Questions and Answers
(30)
HR Interview Questions and Answers
(237)
General Interview Questions and Answers
(9)
Other Interview Questions and Answers
(8)
Job Openings
(3)
Greenplum Database Interview Questions and Answers
(5)
Explain advantages of MyISAM over InnoDB?
Nice?
Vote!
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql-interview-question
mysql
myisam
innodb
1 Answer
Nice?
Vote!
Much more conservative approach to disk space management - each MyISAM table is stored in a separate file, which could be compressed then with myisamchk if needed. With InnoDB the tables are stored in tablespace, and not much further optimization is possible. All data except for TEXT and BLOB can occupy 8,000 bytes at most. No full text indexing is available for InnoDB. TRhe COUNT(*)s execute slower than in MyISAM due to tablespace complexity.
answered
1 year
ago
by
R
(
19,530
points)
Related questions
Nice?
Vote!
1
answer
Explain advantages of InnoDB over MyISAM?
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql-interview-question
mysql
innodb
myisam
Nice?
Vote!
1
answer
Explain the difference between MyISAM Static and MyISAM Dynamic.
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql-interview-question
mysql
Nice?
Vote!
1
answer
Explain TIMESTAMP DEFAULT ‘2006:09:02 17:38:44′ ON UPDATE CURRENT_TIMESTAMP.
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql-interview-question
mysql
timestamp
datatype
Nice?
Vote!
1
answer
Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql-interview-question
mysql
timestamp
Nice?
Vote!
1
answer
Explain the difference between FLOAT, DOUBLE and REAL.
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql
mysql-interview-question
datatype