Re: File full error in simple select statement
Posted by: Peter Brawley
Date: April 23, 2021 09:58AM

Decimal adds another 3.5G, you're still inside your 10G.

Have a look at https://www.percona.com/blog/2019/07/17/mysql-disk-space-exhaustion-for-implicit-temporary-tables/, try stepping back to MyISAM for temp tables.

> This error did not occur when I ran the code on my old computer about a year ago.

Different my.ini settings?

Options: ReplyQuote


Subject
Written By
Posted
Re: File full error in simple select statement
April 23, 2021 09:58AM


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.