Shulou(Shulou.com)06/01 Report--

The main content of this article is to explain "what is the data format of mysql data saved on disk in PHP". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "what is the data format of mysql data saved on disk in PHP"?

What is the data format in which mysql data is saved on disk?

The format in which mysql data is stored on disk in the form of data blocks (block)

Block: a block made up of multiple disk block, which is managed by the storage engine.

The disk is a block block device, and the data on the disk is also stored in blocks.

When mysql reads a table into memory, it must also be read in a block-by-block manner.

Suppose the table to be queried is in the same block as the other tables. When the block is loaded, in addition to reading the table to be queried, other tables are also read out.

When part of a table within a block is deleted, it is fragmented. This slows down loading into memory.

So a block is generated to record the size of a fast inner table, the availability of free space, and the location of free space.

After mysql initialization, the default mysql database format is MyISAM. The format of other databases depends on the default settings.

At this point, I believe you have a deeper understanding of "what is the data format of mysql data saved on disk in PHP". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.