1、权限 授予全局创建临时表权限 GRANT CREATE TEMPORARY TABLES ON . TO ‘bpx’@‘%’; https://cloud.tencent.com/developer/article/1870718 2、大小 show variables like 'tmp%'; tmp_table_size = '1024000';