22 Feb
2019
22 Feb
'19
11:45 a.m.
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