Best MySQL setup for quickly changing large text fields?

Question

I am trying to optimize a MySQL database for a table with the following characteristics.

Any idea? (storage engine, etc.)

Table:

• h

  . 10,000 lines

• each line contains one large text field, size:

  sa 200 kb on average.

  sa 1000 kb max.

• up to several times per second:

  Lines

  deleted and inserted.

  data is added to the text fields.

  text fields are read.

The text field type is currently LONGTEXT, superimposed by Propel ORM CLOB.

Answer 1

As a starting point, I will defend Innodb over MyISAM.

• /.
• , ( innodb)

MySQL Innodb, Barracuda. ( , ):

http://www.mysqlperformanceblog.com/2008/04/23/real-life-use-case-for-barracuda-innodb-file-format/