… port. [Don’t try more than 2; the additional work that the kernel…. You can also use the slave_compressed_protocol option in /etc/my.cnf…recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6…and insert a few rows into an InnoDB table, but trying to run a…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…, nearly 37k NoTPM using 5.6.11 and xfs. …. Snapshots work best with InnoDB, with MyISAM you’ll…compress well showed a compression ration of 1.70 with gzip-1. Real data will compress… 1 or 2 spare drives per controller, I have 2 for the… very interesting solution for MySQL backup servers. All backup…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… Enter MySQL 5.6 with the memcached plugin… As part of the standard MySQL 5.6…57.51′, ‘port’ => 11211, ‘weight’ => 1, ) ), ‘client’ => array( ‘compression‘ => true, ), ); $cache = Zend_Cache::factory(‘Core’, ‘Libmemcached’, $…per/cmd InnoDB Memcache: Storing [100,000] items: 233863 ms total 2.33863 …
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
2 svar: I can confirm that I never was able to get good results with InnoDB compression. Usually it was worse than without compression. So far I can say that I’ve seen only one specific use case useful with InnoDB compression: i.e… InnoDB compression, which is available in MySQL 5.6. So we may test MySQL 5.6 more to see what kind of performance it shows with compression…
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… and InnoDB options are: [mysqld_safe] numa-interleave malloc-lib=/usr/local/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages = none innodb…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…compression ratio. As Innodb indexes are not prefix compressed they have very good compression potential. I also would like to see some stats about compressed… which may come in MySQL 5.2 or even MySQL 5.1. I surely would… available. With current MySQL 5.0 I still see Innodb having serious scalability…
Post: Innodb Caching (part 2)
May 10, 2011 By 7 Comments
…more space with 4K pages – 2.7GB instead of 2.2GB because of larger overhead. …Compression results come as a huge disappointment. The compressed .idb file was only 620MB so if Innodb would chose to keep only compressed… results for 16K and 16K Compressed to be very similar on MySQL 5.5 As a summary: …
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
… 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 we only wanted MySQL… able to leverage pt-online-schema-change from Percona Toolkit 2.1 in order to modify the table if you cannot…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
…InnoDB features in MySQL 5.6 - (Vadim Tkachenko, Percona) – Tuning Innodb is a huge part of my job, and getting up to 5…InnoDB Compression: Present and Future - (Nizameddin Ordulu, Justin Tolmer, Facebook) — The Facebook guys really know their Innodb compression…
Post: Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance
April 29, 2009 By 12 Comments
… 3 innodb versions around. There is MySQL 5.0 version which did not get significant changes for around 2 years now. There is Innodb Plugin which has significant architectural changes such as new storage format, compression and fast index build. Innodb…
