title: the Memory problem about MySQL "SELECT *"
body: <p>I'm new to MySQL, and I have a question about the memory. </p>
  
  <p>I have a 200mb table(MyISAM, 2,000,000 rows), and I try to load all of it to the 
  memory. </p>
  
  <p>I use python(actually MySQLdb in python) with sql: SELECT * FROM <code>table</code>. </p>
  
  <p>However, from my linux "top" I saw this python process uses 50% of my memory(which is total 6GB) </p>
  
  <p>I'm curious about why it uses about 3GB memory only for a 200 mb table. 
  Thanks in advance!</p>