Group By throws table is full

from the Artful MySQL Tips List


Since 8.0.16, a query that may yield a big result can throw a "temp/#sql ... is full" error. The bug is reported here, which says that till the bug is fixed, a workaround is ...
set session internal_tmp_mem_storage_engine=Memory;

Last updated 12 May 2021


Return to the Artful MySQL Tips page