What to do if there are too many blob fields in mysql

Solution to too many blob fields in mysql: It can be solved by setting [binlog_row_p_w_picpath=minimal]. When binlog_row_p_w_picpath=minimal, binlog only records the affected row, reducing the amount of binlog logs.

Problem:

Because there are too many Blob fields in the database, binlog from the database cannot proceed normally.

(Recommended tutorial: mysql video tutorial)

Solution:

Can be solved by setting binlog_row_p_w_picpath=minimal.

Test:

The default value of binlog_row_p_w_picpath is full

Update the user table

Enter binlog View the update record inside. The binlog log records all affected rows

Now set binlog_row_p_w_picpath=minimal

Perform the same update operation on the rows in the table and then observe the binlog records

Conclusion: It can be compared and found that when binlog_row_p_w_picpath=minimal, the binlog only records the affected row. Recording, effectively reducing the amount of binlog logs.

The above is the detailed content of What to do if there are too many blob fields in mysql. For more information, please follow other related articles on the PHP Chinese website!