javaweb，BaseQuery 查询MYSQL的时候出现Row size too large (> 8126) 错误

执行了1跟3。

2在执行的出错，就没去做了。

 

经过测试。只是加了

innodb_file_per_table=1

internal_tmp_disk_storage_engine=MyISAM

就解决了。希望可以对你有所帮助。

 

参考文档  https://stackoverflow.com/questions/15585602/change-limit-for-mysql-row-size-too-large

The method that worked for the OP there was:

1. Add the following to the my.cnf file under [mysqld] section.

   innodb_file_per_table=1
   innodb_file_format = Barracuda
   

2. ALTER the table to use ROW_FORMAT=COMPRESSED.

   ALTER TABLE nombre_tabla
       ENGINE=InnoDB
       ROW_FORMAT=COMPRESSED 
       KEY_BLOCK_SIZE=8;
   

---

There is a possibility that the above still does not resolve your issues. It is a known (and verified) bug with the InnoDB engine, and a temporary fix for now is to fallback to MyISAM engine as temporary storage. So, in your my.cnf file:

3.internal_tmp_disk_storage_engine=MyISAM