MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Barracuda & row_format=compressed to assist denormalization (ERROR 1118)
Posted by: Rick James
Date: December 05, 2013 05:25PM

Consider ROW_FORMAT=DYNAMIC
See: http://www.mysqlperformanceblog.com/2010/02/09/blob-storage-in-innodb/

Consider compressing the bulky VARCHARs in your application, not in the mysql server.

Other limits:
http://dev.mysql.com/doc/refman/5.5/en/innodb-restrictions.html
http://mysql.rjweb.org/doc.php/limits

5.6 does a much better job with ROW_FORMAT=COMPRESSED than does 5.5.

How compressible is your data?

See also: http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-compression-syntax-warnings.html

> create table as select statement to essentially materialize a view

It sounds like you took the view all the way to HTML. That is going too far. Summary tables can be quite efficient.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Barracuda & row_format=compressed to assist denormalization (ERROR 1118)
2332
Lance Woodson
December 02, 2013 08:39PM
Re: Barracuda & row_format=compressed to assist denormalization (ERROR 1118)
912
Rick James
December 05, 2013 05:25PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.