1.查询

show variables like '%MAX_JOIN_SIZE%';

2.设置

set @@local.max_join_size=18446744073709551615, @@global.max_join_size=18446744073709551615;