Log length for MySQL

Log length for MySQL

MySQL defaults to a record with a maximum length of 65535 bytes, with all fields added together, the number of bytes cannot exceed 65535. However, the length of a field in MySQL uses bytes to specify int, and some field types are specified using the number of characters.

What is the 1 characters? Depending on the character encoding,

The latin1 character set is 1 characters and occupies 1 bytes.

GBK Character Set 1 characters occupy 2 bytes

UTF8 Character set 1 characters occupy 3 bytes

You also need to consider the record length of varchar, which needs to be recorded using 1 or 2 bytes.

You also need to consider the issue of null values.

Log length for MySQL