Alexandr Normuradov how to limit the creation on disk temp tables
Sep 28, 2011; 00:04
Alexandr Normuradov
how to limit the creation on disk temp tables
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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=listsearcharchive@lassosoft.com
Sep 28
Johan De Meersman Re: how to limit the creation on disk temp tables
Sep 28, 2011; 07:48
Johan De Meersman
Re: how to limit the creation on disk temp tables
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!