title: MySQL user created temporary table is full
body: <p>I have a created a temporary table using the memory engine as followed:</p>
  
  <pre><code>CREATE TEMPORARY TABLE IF NOT EXISTS some_text (
      id INT DEFAULT 0,
      string varchar(400) DEFAULT ''
  ) engine = memory;
  </code></pre>
  
  <p>When I insert rows into it I run into a #1114 error because the table is full. It explains in the mysql docs that changing the <code>tmp_table_size</code> and the <code>max_heap_table_size</code> don't do anything for increasing the size of user created temp tables, which is what I think I have here. How do I go about making this table larger? </p>
  
  <p>I would love to be able to do this dynamically with a call to SET, but I've tried setting <code>tmp_table_size</code> and the <code>max_heap_table_size</code> and they are both well beyond the amount of data I am expecting in this table. So does anyone know how to resolve this error on this table? Thank you to anyone who helps.</p>