Interested to Buy Any Domain ? << Click Here >> for more details...
Explain advantages of MyISAM over InnoDB?
- 1 Answers
- 6593 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?
How do I download mysql?
What is dbms in mysql?
Why use mysql procedures?
How do you login to MySql using Unix shell?
How to use mysqldump to create a copy of the database?
What is mysqladmin flush hosts?
What is bdb (berkeleydb)?
Restore database (or database table) from backup.
How do I truncate all tables in mysql?
How many queries can mysql handle?
How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
