…(60) DEFAULT ” NOT NULL, PRIMARY KEY (id) ) CREATE INDEX k on sbtest$I(k) and tables sbtest… of TokuDB: it has more than 4x data compression on this dataset. We can easily fill TokuDB… myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related…
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
…, TEXT) in the index record, and the remainder stored in overflow pages. COMPACT became the default after MySQL 5.0.3 and….1 or MySQL 5.5) you can now leverage table compression by specifying ROW_FORMAT=COMPRESSED. In our case we only wanted MySQL to… own page (less the 20 byte pointer stored in the index page). Based on our analysis 75% of the blobs stored…
Post: Large result sets vs. compression protocol
December 20, 2007 By 6 Comments
… interested in a specific one, MYSQL_CLIENT_COMPRESS. This flag tells the client application to enable compression in the network protocol when talking…. The data was textual and compressed well, reducing traffic more than 3 times. With compression, total indexing time reduced to 87 sec from 127 sec. That’s almost 1.5x improvement in total run time. MySQL query…
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… tables BLOB gets its own page (allocated outside of clustered index) if the whole row does not fit in the page…
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
…) before. MySQL Query Anti-Patterns that can be moved to Sphinx - (Vladimir Fedorkov, PalominoDB) Now that Innodb supports Full-text indexing, I…, 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: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… pages for different indexes 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… patch out where already which may come in MySQL 5.2 or even MySQL 5.1. I surely would like to see…
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 4 Comments
… how key compression works. Key compression applies on the block boundaries – first index value is stored fully while for following value index will contain… stored in the index even if it is not packed. Compressed blocks need to be treated differently. For uncompressed index blocks MySQL can do…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… on disk: 42GB (with indexes) # du -sh * 203M ibdata1 128M ib_logfile0 128M ib_logfile1 988K mysql 2.1G ontime1 2.1G… is the excellent compression that RLE techniques provide. I have not loaded InnoDB compressed tables yet but since InnoDB compression is not RLE, I doubt it will have the same impact. For large datasets effective compression…
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… is no index on this table. mysql> delete from data where val=16; Query OK, 1 row affected (3.14 sec) mysql> select…
