title: In which case would MySQL's InnoDB's COMPACT row_format would be faster/better than REDUNDANT?
body: <p>I saw many comparisons on Stackoverflow, DBA and Server Fault, but it's never actually clear when it comes to performance with specific situations, whether using <code>COMPACT</code> or <code>REDUNDANT</code> row format with InnoDB</p>
  
  <p>Are there any cases in which some simple tables would have a definitive performance boost? For example in a simple relational table <code>user_roles</code> that would map a <code>users</code> table with a <code>roles</code> table, using two <code>integers</code> that will always make a row the same size on disk?</p>
  
  <p>If that's not a good example, are there good examples that would make a clear difference?</p>
  
  <p>Thanks!</p>