…. 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: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… excellent compression that RLE techniques provide. I have not loaded InnoDB compressed tables yet but since InnoDB compression is not…mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb…
Post: Innodb Caching (part 2)
May 10, 2011 By 7 Comments
… trying standard Innodb page size, 4KB page size as 16K page size compressed to 4. The data in this case compresses perfectly (all…. Compression results come as a huge disappointment. The compressed .idb file was only 620MB so if Innodb would chose to keep only compressed pages…, though I expect results for 16K and 16K Compressed to be very similar on MySQL 5.5 As a summary: If you…
Post: MySQL Blob Compression performance benefits
January 11, 2008 By 17 Comments
… sense to keep it compressed. Unfortunately MySQL does not provide compressed BLOB/TEXT columns (I would really love to have COMPRESSED attribute for the… with true data size and performance gains, especially for Innodb tables. With Innodb tables BLOB gets its own page (allocated outside of…
Post: InnoDB page sizes: plans and ideas
April 21, 2011 By 9 Comments
… needed ? For InnoDB compression. Right now if you use 16K and trying to compress, the only good choice is to compress to 8K pages (which gives you only 2:1 compress ratio), and… InnoDB really flexible for different type of use cases and storage. As Oracle makes a lot of new good features in MySQL…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…innodb_change_bufferingblogpercona.commanual innodb_checksumsblogpercona.commanual innodb_commit_concurrencyblogpercona.commanual innodb_concurrency_ticketsblogpercona.commanual innodb_data_file_pathblogpercona.commanual Innodb_data_fsyncsblogpercona.commanual innodb…slave_compressed_…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… can use same “cheat” as MySQL 5.5 uses for Innodb Buffer Pool and have multiple MySQL Query Cache instances hashed by query… is highly compressible and light compression can compress results at faster than wire speed for 1Gb networks. Plus if we can get MySQL protocol to support such light compression in addition to zlib we could stream compressed results directly from storage and only de-compress…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…:17 InnoDB: Compressed tables use zlib 1.2.3 120619 13:21:17 InnoDB: Using Linux native AIO 120619 13:21:17 InnoDB: Initializing…=oltp –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp…
Post: Facebook at Percona Live MySQL Conference and Expo and Advanced Registration Ending Soon
March 19, 2013 By Leave a Comment
… Live MySQL Conference and Expo by Facebook technical experts include: Nizameddin Ordulu, Software Engineer, and Justin Tomer, Software Engineer, will present “InnoDB Compression: Present and Future”. They will discuss Facebook’s compression improvements and the internal details of…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
… January I have created the outline of improvements available in MySQL 5.6 which I thought was worth sharing to give… N – Persistent Statistics for Innodb – Improvements to Innodb Compression – Fast Page Checksums (CRC32) – 4K and 8K Page sizes for Innodb – Improvement to Buffer Pool…
