… the TEXT field was compressed which we felt indicated there would be a benefit derived from table compression. With the original InnoDB….1 or MySQL 5.5) you can now leverage table compression by specifying ROW_FORMAT=COMPRESSED. In our case we only wanted MySQL to… InnoDB system tablespace cannot be compressed, see this page for further details on how to enable compression for a table. To utilize…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
… regular tables: 19693 sec, for compressed tables: 38278 sec. Compressed tables are create as: ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8, with final…=16 –max-requests=0 –rand-type=uniform –max-time=1800 –mysql-user=root –report-interval=10 run this will report us… sec. I expected some overhead for compressed tables, but not such: the throughput with compressed tables are 30 transactions per sec. This…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… 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: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… constantly referring to the amazing MySQL manual, especially the option and variable reference table. But…skip_symbolic_linksblogpercona.commanual skip_thread_priorityblogpercona.commanual slave_compressed_protocolblogpercona.commanual slave_exec_modeblogpercona.commanual Slave_heartbeat_…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
…, Justin Tolmer, Facebook) — The Facebook guys really know their Innodb compression, and now that their enhancements are in 5.6, I… instruction about what some migration strategies might look like. Using MySQL Performance Schema to debug performance issues - (Zburivsky Danil, Pythian) – I…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
Backing up MySQL Database most people compress them – which can make a good sense in terms of …. Also note the serious leap in compressed file size. Though in this example we used MySQL binary log file which often contains… LZO default compression file compressed in 10.5 seconds and resulted in 390MB compressed file, this gives us 97MB/sec compression speed which is…
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 with console MySQL tools. Some people get best of both worlds by taking COMPRESS/UNCOMPRESS functions from the MySQL code and having…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… may well have very different 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 tables, such as… patch out where already which may come in MySQL 5.2 or even MySQL 5.1. I surely would like to see…
Post: Adventures in archiving
February 11, 2013 By 16 Comments
… further testing. InnoDB’s inbuilt row compression MySQL‘s inbuilt compress() function leveraging zlib to provide compression of data. MySQL‘s Archive storage engine. Tooling… | +———+ | 1143883 | +———+ 1 row in set (2.04 sec) mysql> select id from compressed_row order by id desc limit 1; +———+ | id | +———+ | 1143883…
Post: The case for getting rid of duplicate “sets”
May 17, 2011 By 2 Comments
… * from compressed join search_set using (val) where compressed.cnt >= search_set.cnt; mysql> select * from compressed join search_set using (val) where compressed.cnt….00 sec) mysql> delete from compressed where val=16; Query OK, 1 row affected (0.00 sec) mysql> select * from compressed join search_set…
