List:General Discussion« Previous MessageNext Message »
From:Alexandr Normuradov Date:September 28 2011 5:04am
Subject:how to limit the creation on disk temp tables
View as plain text  
Hello List,

so far I could not find any answer on how to abort queries that exceed
certain size of internal temporary tables.

On certain quite often scenarios these internal tables are being
converted to Myisam on disk tables. And that creates a high IO
depending on situation.

Putting tmpdir in tmpfs solves half of the problem.

Have anyone came up with a better approach on how to restrict them?


Sincerely,
Alexandr N
Thread
how to limit the creation on disk temp tablesAlexandr Normuradov28 Sep
  • Re: how to limit the creation on disk temp tablesJohan De Meersman28 Sep