Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about the difference between static tables and dynamic tables in mysql. Many people may not know much about it. In order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

Static table field length is fixed, automatic filling, read and write speed is very fast, easy to cache and repair, but compared to the hard disk, dynamic table is the field length is not fixed, saving hard disk, but more complex, easy to produce fragments, slow speed, after the problem is not easy to rebuild.

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 transactions, while the InnoDB type does. Tables of type MyISAM emphasize performance and perform several times faster than type InnoDB, but do not provide transaction support, while InnoDB provides advanced features such as transaction support already foreign keys.

MyIASM is a new version of the IASM table with the following extensions:

Portability at the binary level.

NULL column index.

There is less fragmentation for variable-length rows than for ISAM tables.

Large files are supported.

Better index compression.

Better keys? statistical distribution.

Better and faster auto_increment processing.

The biggest advantage of 1.MySQL lies in the simple SELECT,INSERT and UPDATE fast operation under the MyISAM engine.

It is important that data files of type 2.MyISAM can be COPY in different operating systems, and it is convenient to deploy.

Here are some of the details and differences in implementation:

1.InnoDB does not support indexes of type FULLTEXT.

The specific number of rows of the table is not saved in 2.InnoDB, that is, when select count (*) from table is executed, InnoDB scans the entire table to calculate how many rows there are, but MyISAM can simply read out the number of saved rows. Note that when the count (*) statement contains the where condition, the operation of the two tables is the same.

After reading the above, do you have any further understanding of the difference between static tables and dynamic tables in mysql? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.