mysql 8 - linux 安装后 java 调用报错 SQLException: Temporary file write failure
完整报错
Cause: java.sql.SQLException: Temporary file write failure. ; uncategorized SQLException; SQL state
[HY000]; error code [1878]; Temporary file write failure.; nested exception is java.sql.SQLException: Temporary file write failure.
解决
不要作用在指定表，应该执行在最外层
set global join_buffer_size = 1024*1024*1024;
show VARIABLES like '%join_buffer%';
