mariadb ketika import error gini Row size too large (> 8126) solusinya ?
  easystem   01 Oktober 2023   fix error

Solusi Ke 1 :

The error message Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. means that the row size of a table in MySQL is larger than the maximum row size of 8126 bytes. This can happen if the table has a lot of columns, or if the columns are of a data type that takes up a lot of space, such as VARCHAR or TEXT.

To fix this error, you can try the following:

  • Change some columns to TEXT or BLOB. TEXT and BLOB columns can store large amounts of data, so changing some of your columns to these data types may help to reduce the row size.
  • Use a different row format. The default row format in MySQL is Compact. This row format stores data efficiently, but it has a maximum row size of 8126 bytes. You can change the row format of a table to Dynamic or Compressed. These row formats have a larger maximum row size, but they may not be as efficient as the Compact row format.
  • Split the table into two or more tables. If you have a table with a lot of columns, you can try splitting it into two or more tables. This will reduce the row size of each table, and it may also improve performance.

If you are not sure which solution is best for you, you can consult with a MySQL expert.

Here are some additional tips for avoiding row size errors:

  • Use the correct data type for each column. For example, if you are storing a short string of text, use a VARCHAR column instead of a TEXT column.
  • Normalize your database. This means splitting your data into multiple tables, each of which stores a specific type of data. This can help to reduce the row size of each table.
  • Use indexes. Indexes can improve the performance of your database queries, and they can also help to reduce the amount of memory that your database uses.

Solusi Ke 2 :

Pada Bagian my.cnf atau server.cnf tambahkan setelah 

[mysqld]

innodb_strict_mode = 0

Tags :

mysql , 8126 , mariadb

Bagikan :