What is the difference between mysql static tables and dynamic tables? What is the difference between MyISAM and InnoDB?

Static table fields have fixed length, automatic filling, fast read/write speeds, and are easy to cache and repair. However, dynamic table fields are not fixed in length, saving hard disks but making them more complex, fragments are easy to generate, and the speed is slow. reconstruction is not easy after a problem occurs.
3InnoDB and MyISAM are the two most commonly used table types in MySQL, each with its own advantages and disadvantages, depending on the specific application. The basic difference is that the MyISAM type does not support advanced processing such as transaction processing, while the InnoDB type does. MyISAM tables emphasize performance, and the execution speed is faster than that of InnoDB, but transactions are not supported. InnoDB provides advanced database functions such as external keys for transactions.
MyIASM is a new version of the IASM table and has the following extensions:
Binary hierarchy portability.
NULL column index.
There are fewer fragments for Long-varying rows than the ISAM table.
Supports large files.
Better index compression.
Better key? statistical distribution.
Better and faster auto_increment processing.
1. The biggest advantage of MySQL is the simple SELECT, INSERT, and UPDATE operations under the MyISAM engine.
2. MyISAM data files can be copied in different operating systems, which is very important and convenient for deployment.
The following are some differences between details and specific implementations:
1. InnoDB does not support FULLTEXT indexes.
2. innoDB does not store the specific number of rows in the table. That is to say, when you execute select count (*) from table, InnoDB needs to scan the entire table to calculate the number of rows, however, MyISAM simply needs to read the number of lines saved. Note that when the count (*) statement contains the where condition, the operations on the two tables are the same.

 

This article is from "Jesus"