how to limit the creation on disk temp tables

2011-09-27 Thread 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

Re: how to limit the creation on disk temp tables

2011-09-27 Thread Johan De Meersman
- Original Message - From: Alexandr Normuradov norma...@gmail.com so far I could not find any answer on how to abort queries that exceed certain size of internal temporary tables. I'm not sure there is. On certain quite often scenarios these internal tables are being converted to