title: Slow DROP TEMPORARY TABLE
body: <p>Ran into an interesting problem with a MySQL table I was building as a temporary table for reporting purposes.  </p>
  
  <p>I found that if I didn't specify a storage engine, the DROP TEMPORARY TABLE command would hang for up to half a second.  </p>
  
  <p>If I defined my table as ENGINE = MEMORY this short hang would disappear.  </p>
  
  <p>As I have a solution to this problem (using MEMORY tables), my question is why would a temporary table take a long time to drop?  Do they not use the MEMORY engine by default?  It's not even a very big table, a couple of hundred rows with my current test data.  </p>