Relational query, Planetscale throws: `ResourceExhausted desc = Out of sort memory`
SOLUTION: the problem was that I had a json column storing a massive value on each row.
Possible reasons?
The logged sql statement selects all 78 columns. Shouldn't it only need need ~two columns for relation lookup?
code = ResourceExhausted desc = Out of sort memory, consider increasing server sort buffer size (errno 1038) (sqlstate HY001)Possible reasons?
- bloated table:
76columns, half of typejson()ortext()– but only 228 rows – total db size only1.61MB - drizzle relational query over-selecting?
The logged sql statement selects all 78 columns. Shouldn't it only need need ~two columns for relation lookup?