… documentation for setting up the plugin: http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-setup.html As…=> ’192.168.57.51′, ‘port’ => 11211, ‘weight’ => 1, ) ), ‘client’ => array( ‘compression‘ => true, ), ); $cache = Zend_Cache::factory(‘Core’, ‘Libmemcached’, $frontendOpts, $memcacheOpts); …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… data compression on this dataset. We can easily fill TokuDB tables with 1bln of rows on this SSD, and projected InnoDB performance…_group = 2 innodb_log_block_size=4096 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native…
Post: Real-Life Use Case for "Barracuda" InnoDB File Format
April 23, 2008 By 11 Comments
… using new InnoDB file format but in this post I’d like to share some real-life example how compression in InnoDB plugin could… convert customer’s data to Barracuda file format using new InnoDB plugin recently released by Oracle. First thing I’ve tried was… index pages compression (by default it is trying to compress 16kb pages down to 8kb) new innodb plugin performs TEXT/BLOB/VARCHAR fields compression off…
Post: Blob Storage in Innodb
February 9, 2010 By 13 Comments
… (used in before Innodb plugin and named “Antelope” in Innodb Plugin and XtraDB) Innodb would try to fit the whole row onto Innodb page. At least… large Blob (and potentially compress it) If all columns do not fit to the page completely Innodb will automatically chose some of… and the fix comes with Innodb Plugin in “Barracuda” format and ROW_FORMAT=DYNAMIC. In this format Innodb stores either whole blob on…
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
…. Using InnoDB’s new Barracuda file format (available since InnoDB plugin 1.1 or MySQL 5.5) you can now leverage table compression by specifying ROW_FORMAT=COMPRESSED. In our case… innodb_file_format=BARRACUDA; One caveat: you must be running with innodb_file_per_table=1 as the InnoDB system tablespace cannot be compressed…
Post: INFORMATION_SCHEMA tables in the InnoDB pluggable storage engine
May 24, 2008 By Leave a Comment
…InnoDB locks even in the older versions of InnoDB, but it’s not really easy.) These tables are fully documented in the InnoDB plugin…
Post: Great work Innodb Team
November 30, 2009 By 8 Comments
… fixed now. Innodb plugin documentation now seems to be merged with MySQL Documentation which makes it much more usable and Innodb Plugin is shipped… public release and probably 4 years since the work on Innodb plugin features such as compression or Online index creation has started.
Post: Interested to learn about New Innodb Plugin Performance ?
April 15, 2008 By 2 Comments
As you probably have already heard Innodb Announced new Plugin version for MySQL 5.1 So now you can see … less than 24 hours) as well as performance improvements to compression and fast index build functionality. As it is now publicly… followed by my presentation on Innodb Scalability Limits. I will not go a lot into this plugin performance because I did not…
Comment: Extending Index for Innodb tables can hurt performance in a surprising way
May 22, 2010 By 10 Comments
Hi Peter, I’ve seen inconsistent behavior in MySQL/InnoDB with regard to PK being suffix of all indexes. That … the future: I found temporary tables to behave differently with InnoDB plugin compressed format — but, again, inconsistently. Regards
Comment: Should you move from MyISAM to Innodb ?
January 21, 2009 By 59 Comments
We are having performance difficulties with the innodb plugin from innodb.com , using ver. 1.01 and mysql 5.1.24: … partitioned (with 1024 partitions each), the innodb_file_per_table is on, and data is compressed (key-buffer-size=4). Total db… compression). Without partitions, the innodb plugin was o.k., slower than MYISAM (incl. inserts, selects) but still o.k. Unfortunately we need the compression…
