Re: mysql 5.8, group by causing temp file full error
> trying to migrate from 5.6 to 5.8
There's no version 5.8. You mean 8.0?
> table '/var/lib/mysql/tmp/#sql2d349_80_d' is full!
Did you try increasing tmp_table_size, max_heap_table_size?
If that doesn't fix the issue, let's see the query and its Explain result along with Show Create table results for all tables.
Subject
Written By
Posted
Re: mysql 5.8, group by causing temp file full error
January 19, 2020 10:46PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.