Re: File full error in simple select statement
Posted by: Derek McKinnon
Date: May 10, 2021 09:08PM

Yes, while the code was running to collected that status.

The error still occurs when innodb_thread_concurrency=0.


SET GLOBAL internal_tmp_disk_storage_engine = MYISAM;

This resulted in an error "Unknown system variable 'internal_tmp_disk_storage_engine'"

@@innodb_temp_data_file_path
ibtmp1:12M:autoextend

Yes, I've read through that article previously. Some of it isn't applicable to MySQL 8, and the rest didn't work.

Options: ReplyQuote


Subject
Written By
Posted
Re: File full error in simple select statement
May 10, 2021 09:08PM


Sorry, only registered users may post in this forum.

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.