… versions, compression was only possible with streaming backups + external (usually single-threaded) compression utilities,…Percona XtraBackup against debug versions of InnoDB. This is only for very advanced …topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically,…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
InnoDB compression is getting some traction, and I see quite contradictory opinions. Someone has successful deployments in productions, and someone says that compression…=16 –max-requests=0 –rand-type=uniform –max-time=1800 –mysql-user=root –report-interval=10 run this will report us…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… storage engine for MySQL – Innodb. Innodb Storage Engine was covered in a lot of talks, many of them done by Innodb users. I found… 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…
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 8 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 63 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…
Comment: Compression for InnoDB backup
March 18, 2009 By 19 Comments
lzjb Reminds me of discussions in this post: ZFS & MySQL/InnoDB Compression Update http://blogs.smugmug.com/don/2008/10/13/zfs-mysqlinnodb-compression-update/
