… 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… with current compression settings. The same utility could be used to advice on the compression page settings by looking at compressed page size… 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
… if it is not packed. Compressed blocks need to be treated differently. For uncompressed index blocks MySQL can do binary search inside… for left or right half. For compressed block this is not going to work and MySQL will need to scan keyblock from… by packing them it is almost no brainer Summary: Key prefix compression is cool feature and may give great space savings. Defaults…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…to go with gzip compression instead of implementing “classical” approach of index prefix compression ? HT: The reason is that index prefix compression prevents one from…additional throughput? HT: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_…
Post: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
… id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.1.67-14.4[/caption] Percona is glad… an INSERT or UPDATE statement containing BLOB values for a compressed table. This regression was introduced in Percona Server 5.1…, but it is also a prefix of another command line option innodb_changed_pages_limit. MySQL option handling would then shadow the…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
… available here and from the Percona Software Repositories). Based on MySQL 5.5.29, including all the bug fixes in it… an INSERT or UPDATE statement containing BLOB values for a compressed table. This regression was introduced in Percona Server 5.5…, but it is also a prefix of another command line option innodb_changed_pages_limit. MySQL option handling would then shadow the…
Post: Blob Storage in Innodb
February 9, 2010 By 13 Comments
… storage was not very efficient in REDUNDANT (MySQL 4.1 and below) and COMPACT (MySQL 5.0 and above) format and the… column prefix to be stored on the page – you can build prefix indexes on blobs which are often stored outside the page. COMPRESSED… strategy storing BLOBs completely off page. It however will always compress blobs which do not fit to the row page, even…
