title: mysql - can I determine or limit the amount of memory query is allowed to use
body: <p>I am running a query that creates a temporary table however the limit is 64mb and I am not able to change the limit due to access permissions etc.  When a large date range is selected the temporary table runs out of space and results in a mysql error.</p>
  
  <p>Is there anyway I can determine the size or amount of memory the query will use before attempting to run the query, so I can avoid the above problem gracefully?</p>