title: Best MySQL setup for rapidly changing big text fields?
body: <p>I am trying to optimize a MySQL database for a table with the following characteristics.</p>
  
  <p><em>Any idea? (storage engine, etc.)</em></p>
  
  <p>The table:</p>
  
  <ul>
  <li><p>ca. 10,000 rows</p></li>
  <li><p>each row contains one big text field, sized:</p>
  
  <p>ca. 200 kByte on average.</p>
  
  <p>ca. 1000 kByte maximally.</p></li>
  <li><p>up to several times per second:</p>
  
  <p>rows are deleted and inserted.</p>
  
  <p>data is appended to the text fields.</p>
  
  <p>the text fields are read.</p></li>
  </ul>
  
  <p>The type of the text field is currently LONGTEXT, as imposed by Propel ORM's CLOB.</p>