title: MySQL - Barracuda file format & row compression to avoid ERROR 1118 Row Size Too Large
body: <p>I am attempting to get row compression working with mysql 5.5.31 (community edition) to avoid getting the following error when denormalizing in a warehousing-type context.</p>
  
  <pre><code>ERROR 1118 (42000): Row size too large. The maximum row size for the used
  table type, not counting BLOBs, is 65535. You have to change some columns
  to TEXT or BLOBs
  </code></pre>
  
  <p>I have enabled the various system variables as follows:</p>
  
  <pre><code>mysql&gt; show variables like 'innodb_file%';
  +--------------------------+-----------+
  | Variable_name            | Value     |
  +--------------------------+-----------+
  | innodb_file_format       | Barracuda |
  | innodb_file_format_check | ON        |
  | innodb_file_format_max   | Barracuda |
  | innodb_file_per_table    | ON        |
  +--------------------------+-----------+
  </code></pre>
  
  <p>But when I attempt to do the following as a test, I still get the same row size too large errors.</p>
  
  <pre><code>create table foo (  first varchar(10000),
      second varchar(10000),
      third varchar(10000),
      fourth varchar(10000),
      fifth varchar(10000),
      sixth varchar(10000),
      seventh varchar(10000)
   ) ENGINE=InnoDB ROW_FORMAT=Compressed KEY_BLOCK_SIZE=8;
  </code></pre>
  
  <p>Does anyone know what I might be missing here?  There are several sources that indicate this should work.</p>
  
  <p><a href="https://stackoverflow.com/questions/10349361/mysql-how-to-workaround-the-row-size-limit-of-66-kbytes/20279228#20279228">MYSQL - How to workaround the row size limit of 66 KBytes</a></p>
  
  <p><a href="https://stackoverflow.com/questions/15585602/change-limit-for-mysql-row-size-too-large/15585700#15585700">Change limit for &quot;Mysql Row size too large&quot;</a></p>
  
  <p><a href="https://stackoverflow.com/questions/13707210/django-mysql-enable-row-format-compress-with-syncdb/13710510#13710510">Django-MySQL enable Row_Format=Compress with syncdb</a></p>