spring boot useServerPrepStmts=true可能引起的异常

MyBatis 配置一下参数有可能会引起mysql抛出异常：

When 'us
eServerPrepStmts=true', 'maxAllowedPacket' must be higher than 8203. Check also
'max_allowed_packet' in MySQL configuration files.

datasource.addDataSourceProperty("cachePrepStmts", "true");datasource.addDataSourceProperty("prepStmtCacheSize", "250");datasource.addDataSourceProperty("prepStmtCacheSqlLimit", "1024");datasource.addDataSourceProperty("useServerPrepStmts", "true");

解决方式是在mysql的配置文件最后加

max_allowed_packet = 20M