Re: File full error in simple select statement

[Derek McKinnon]

Hi. Thanks for your reply.

No, I did not know about that setting. Reading the online help does indicate it should be the problem.

However now I can't change the value.

This is on my own laptop, logged in as root, so I checked and I do have super user privileges.

However

SHOW VARIABLES WHERE Variable_name = "max_heap_table_size";
SET PERSIST max_heap_table_size = 1000000000;
SHOW VARIABLES WHERE Variable_name = "max_heap_table_size";

Returns the same value for max_heap_table_size both before and after. I have also tried using the @@ syntax.

Any ideas?
Thanks
Derek