…We should however see how “compact” they would be in real world cases and how much…data (it is not implemented in MySQL anyway though). Very interesting to see how this one will compare to transparent gzip page compression… typical for MySQL use of Databases just as directories it can be the problem…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…data and for various indexes. How many “fragmented” pages do we have in the index with current compression settings. The same utility could be used…uses dynamic or static record format ? (static record format for sort used by MyISAM may cause sort files to be much… many MySQL patches so we can call …
Post: Trying Archive Storage Engine
November 12, 2006 By 7 Comments
…mysql mysql 9162 Nov 12 11:00 requests_061111.frm Can‘t say I’m impressed we have only about 2 times compression…how much table would take if compressed with bzip2 – it took a while to compress but result was 310MB 40% better than compressed…
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 4 Comments
…. First lets see how key compression works. Key compression applies on the …compression applies to data pointer for the same key value. It also can be used…Compressed blocks need to be treated differently. For uncompressed index blocks MySQL can… 1.26s So we can see theory goes pretty much in hand with…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… form, but OS Cache can keep compressed pages in memory. For the data set we tested, TokuDB used 6.2x less disk space… schema, in two modes – 1. data size is much more then memory and 2. data fits into memory. As you see… going to be fixed in MySQL 6.0, but I can‘t yet say how it will work with mix of…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… systems are much farther from …, I learned how to distribute …data from all the nodes. A single temporary table is used to store the results from all the nodes. Since we…data on which your queries operate. It can, however, use… now only MySQL storage nodes … items * IN list compression is not required…
Post: To UUID or not to UUID ?
March 13, 2007 By 28 Comments
…we want – if we access “recent” items more frequently and data set is large auto_increment would work much…can do them pretty efficient by using binary compression. Plus they should be stored in optimized sort order to minimize how…
Post: Intro to OLAP
July 12, 2010 By 10 Comments
…using MySQL…compression of data which can improve performance. Loading data…data, much more than a spreadsheet can usually handle. MOLAP servers usually require that all, or almost all of the data…
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
…we have one that covers the very basics of how MySQL replication really works on the high level. Or it’s been so long ago I can…file stores data that …’s used for … slave compressed protocol. …can do much more IO operations per second even with a single thread – fastest traditional disks can…
Post: Blob Storage in Innodb
February 9, 2010 By 13 Comments
…But before we look into how BLOBs…use external blob storage pages. For example 7KB blob can…Much better decision in many cases could be combine data in the single large Blob (and potentially compress…we‘ll come to implementing this in XtraDB 
So BLOB storage was not very efficient in REDUNDANT (MySQL…
