MySQL FAQs
FAQs Categories
Client Server Commands
Database Structure
Table Types or Storage Engines
Indexes
SQL Statements
Table Joins
Funtions and Operators
Tricky Select Queries
Speed Up Queries
Data Back Up
General Questions
Errors
N.M.P.L. Company www.NearMePayday.Loan || 3-month (90 days)
Powered by MySQL
 

What are MyISAM table characteristics?

Can I know, what are MySQL's MyISAM table characteristics?

Answer No: 169

MyISAM is based on the older ISAM code and has many useful extensions. It has several features.  The following are its some major characteristics:

  • MyISAM tables are operating system independent, so it is easy to port them from a Windows server to a Linux server.
  • MyISAM tables are typically capable of storing more data, but at a cost of less storage space than their older counterpart.
  • MyISAM tables have the convenience of a number of data integrity and compression tools at their disposal, all such tools are bundled with MySQL.
  • MyISAM tables do not support transactions.
  • MyISAM tables are free from extra overhead required of transactional storage engines such as InnoDB and BDB.
  • MyISAM storage engine is quite fast at sifting through large amounts of data, even in a high-traffic environment.
  • MyISAM has great concurrent insert feature. It allows for data to be selected and inserted simultaneously. For example, the MyISAM storage engine would be a great candidate for managing mail or Web server log data.
  • MyISAM engine manages three formats: static, dynamic, and compressed. MySQL automatically applies the best type in accordance with the specifics of the table structure.

Related MySQL FAQs to the Above FAQ

What-are-MyISAM-formats-in-MySQL What are MyISAM formats in MySQL?

How-to-create-myisam-table-in-MySQL How to create myisam table in MySQL?

How-MySQL-myisam-table-is-stored-on-disk How MySQL myisam table is stored on disk?

About FAQs: Recently Added FAQs

About MySQL FAQs: Site Map | Bookmark Us | Recommend this Site to Your Friend | Contact Us

Useful Links: Wikipedia.org | Oracle.com | w3schools.com | www.php.net | Github.com

© 2021  www.mysqlfaqs.net
All rights reserved.