TestingDocs.com
    Software Testing website
    • Automation
      • Selenium
      • JBehave Framework
    • Tutorials
      • MySQL Tutorials
      • Testlink
      • Maven
      • Git
    • IDEs
      • IntelliJ IDEA
      • Eclipse
    • Flowcharts
      • Flowgorithm
      • Raptor
    • About

    MySQL

    MySQL MyISAM Storage Engine

    Overview

    In this tutorial, we will learn about MyISAM Storage Engine. MyISAM was the default storage engine for older MySQL versions until it was replaced by InnoDB in MySQL 5.x.

    MyISAM Storage Engine

    MyISAM storage engine is based on Indexed Sequential Access Method(ISAM) indexing algorithm that retrieves information from large sets of data in a fast manner.

    MyISAM is a non-transactional engine, light with high-speed performance, portable easy to copy between
    systems and has a small data footprint. The MyISAM storage engine manages tables that have the following characteristics:

    Represents each table using multiples files like :

    • A data file(.myd) that stores the contents of table rows.
    • An index file(.myi) that stores any indexes on the table.

    Tables can be converted into fast, compressed, read-only tables to save space.

    The table storage format is portable, so table files can be copied directly to another host.

    We can specify preference of number of rows that a table should hold (minimum or maximum)

    Storage Formats

    The MyISAM storage engine supports three different table storage formats

    • FIXED Format
    • DYNAMIC Format
    • COMPRESSED Format

    FIXED format

    All rows have the same size.

    Rows are stored within the table at positions that are multiples of the row size, for easy to look up.

    Fixed-size rows take more space.

    DYNAMIC format

    Rows take varying amounts of space.

    Rows cannot be looked up as efficiently.

    Dynamic-rows tables usually take less space because rows are not padded to a fixed size.

    Fragmentation can occur more easily than for fixed- row tables.

    COMPRESSED format

    Tables are packed to save space.

    Storage is optimized for quick retrieval.

    Tables are read-only.

    —

    MySQL Tutorials

    MySQL Tutorials on this website:

    https://www.testingdocs.com/mysql-tutorials-for-beginners/

    For more information on MySQL Database:

    https://www.mysql.com/

    Related Posts

    Stellar Converter for Database Tool

    MySQL /

    Stellar Converter for Database

    Stellar MySQL Log Analyzer

    MySQL /

    Stellar Log Analyzer for MySQL

    Stellar Repair for MySQL

    MySQL /

    Stellar Repair for MySQL

    MySQL /

    How to secure your SQL Database: Tips and Tricks

    Stellar Converter for Database

    MySQL /

    Database Converter Tools

    ‹ MySQL InnoDB Storage Engine› MySQL MEMORY Storage Engine

    Recent Posts

    • ChatGPT Plans Free and PlusChatGPT Subscription Plans
    • Stellar Converter for Database ToolStellar Converter for Database
    • Stellar MySQL Log AnalyzerStellar Log Analyzer for MySQL
    • Stellar Repair for MySQLStellar Repair for MySQL
    • ChatGPT IntroductionChatGPT Capabilities
    • How to secure your SQL Database: Tips and Tricks
    • ChatGPT4 Conversational AI FeaturesChatGPT4 Conversational AI Features
    • Trends in Software EngineeringShaping the Future of Development: Exploring Key Trends in Software Engineering
    • Java PerformanceImproving Java Performance with Multithreading
    • QDrant Vector DatabaseOpen-source Vector Databases
    • Difference between PHP and JavaScript?
    • Bing AI Browser Web ContentBing Conversation Styles
    • ChatGPT PreviewChatGPT Introduction
    • Open Source AI Frameworks TensorFlowOpen Source AI Frameworks
    • Artificial Intelligence Tools

    Back to Top

    Links

    • Contact
    • Privacy Policy
    • Cookie Policy

    www.TestingDocs.com