Re: mysql 5.8, group by causing temp file full error
Posted by: Peter Brawley
Date: January 20, 2020 10:48AM

What are the old and new values of innodb_data_file_path, tmp_table_size, max_heap_table_size?

Please post here the OS & version number of it, MySQL version number, the full error log entry relevant to the error, the full query, the Explain result on the query inside BBCode code tags, and the Show Create Table result for each referenced table.



Edited 1 time(s). Last edit at 01/20/2020 10:48AM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
Re: mysql 5.8, group by causing temp file full error
January 20, 2020 10:48AM


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.