maria-discuss team mailing list archive

[Benoit Plessis <benoit+one@xxxxxxxxxxxx>]

On 22/02/2019 00:03, Benoit Plessis wrote:
> On 21/02/2019 23:40, Justin Swanhart wrote:
>> It is possible that the two versions have different query plans, with the new version requiring more temp space.  It is also possible that different temporary table engines are in use.  Check to make sure you are using aria for temp tables and not innodb.
>>
> Yes i was using Aria for tmp storage engine, i switched to myisam like
> in mysql 5.5, and it seem to have a nice effect on tmp space used for now !

It's going way better (for the /tmp space at least) with
tmp_storage_engine as MyISAM, a request that take ~7Go of tmp storage
with Aria storage fit nicely and "fastly" in the 512M memory table limit