What is the Blob,mysql blob size configuration description font: [Increase decrease] Type: Reprint blob (binary large object), binary large object, is a container that can store binary files. In a computer, a BLOB is often the field type used to store a binary file in a database blob is a large file, a typical blob is a picture or a sound file, and due to their size, they must be handled in a special way (for example, uploading, downloading, or storing it in a database). According to Eric Raymond, the main idea of dealing with blobs is to let a file processor (such as a database manager) ignore what the file is, but rather care about how to handle it. But there are also experts who stress that the way to handle big data objects is to double-edged swords, which may cause problems such as storing binary files too large, which can degrade the performance of the database. Storing large multimedia objects in a database is a typical example of application processing blobs.
MySQL blob type
In MySQL, BLOBs are a series of types, including: Tinyblob, BLOBs, Mediumblob, Longblob, the only difference between these types is the maximum size of the storage file.
MySQL four types of blobs
Type size (units: bytes)
Tinyblob Max 255
Blob Max 65K
Mediumblob Max 16M
Longblob Max 4G
Linux Modify Etc/my.cnf
[Mysqld]
Max_allowed_packet = 16M//differs from max_allowed_packet under [mysqldump]
What is blob,mysql BLOB size configuration Introduction
