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 _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
