title: How to make the mysql MEMORY ENGINE store more data?
body: <p>I want to alter a table from INNODB to MEMORY ENGINE.</p>
  
  <p>So I typed this command:</p>
  
  <p><code>alter table sns ENGINE=MEMORY;</code></p>
  
  <p>Then the MySQL shows </p>
  
  <pre><code>ERROR 1114 (HY000): The table '#sql-738_19' is full
  </code></pre>
  
  <p>The data size for the table is 1GB, and I have 8GB Memory.</p>
  
  <p>I checked my.cnf, and I didn't find where to change the max_size setting.  Shouldn't I be able to store more data?</p>