mysql 5.8, group by causing temp file full error
Posted by: chase miller
Date: January 19, 2020 09:40PM

Hello,

We are trying to migrate from 5.6 to 5.8, and in our testing of our application, we have a query that is doing a group by, and it's throwing this error message:
[ERROR] [MY-013132] [Server] The table '/var/lib/mysql/tmp/#sql2d349_80_d' is full!

any help on what innodb variable we may need to tune? we have tried many, with no luck

thx

Options: ReplyQuote


Subject
Written By
Posted
mysql 5.8, group by causing temp file full error
January 19, 2020 09:40PM


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.