how to limit the creation on disk temp tables

[Alexandr Normuradov]

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