Answer Posted / amith
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.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Is there a free mysql?
What are the security alerts while using mysql?
Is mysql free software?
Write a query to stop mysql in unix
List data types in mysql? Explain
How do I install the latest mysql on ubuntu?
How do I find my mysql username and password?
How to list or view all databases from the mysql server.
What is mysql and how it works?
How do I download mysql on my laptop?
What is the use of concat() in mysql?
What are the difference between mongodb and mysql?
How to shutdown mysql server?
How to get a list of columns in an existing table?
How to convert character strings to dates?