…compressed file. This gives us compression speed of about 21MB/sec – clearly much less than even single SATA hard drive can…compressed file size. Though in this example we used MySQL…can pass through 1Gbit ethernet, meaning you actually can use LZO compression for faster data…
Post: The case for getting rid of duplicate “sets”
May 17, 2011 By 2 Comments
…How can we effectively reduce the data size of any set, possibly by orders of magnitude, with almost no work? Simple, we…compressed join search_set using (val) where compressed.cnt >= search_set.cnt; mysql> select * from compressed join search_set using (val) where compressed…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…data archiving on my own blog a while back. The benefits of purging and archiving data can…can be overcome, but how much time do you have? And the gains are simply limited by some of MySQL…
Post: Innodb Caching (part 2)
May 10, 2011 By 7 Comments
…compression. Here is the graph: The results are quite interesting from a lot of angles. First we can see how quickly performance can…MySQL 5.5 As a summary: If you have very random access pattern with small rows consider using 4K pages, compression…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…much information. This can cause the disk to fill up with logs. You can…compression results in the need for fewer nodes in order to keep data entirely in memory. This frees disk to use…mysql wait-timeout=86400 To be continued You can…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…MISC part, it tells you how much of “load” is not covered by top queries, we have 10% in …you can use to gather more data about the underlying tables involved and the query execution plan used by MySQL. … might even compress the values stored in the option_value column so that less data is read and…
Post: Using CHAR keys for joins, how much is the overhead ?
June 18, 2007 By 18 Comments
… below are for MySQL 5.1.18 using MyISAM and…row data from OS Cache. So what if we … expected as MyISAM uses key compression for varchar columns … but gave me much longer keys. The …how do I read these results ? CHAR keys are indeed slower for joins compared to integer keys Performance degradation can…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…use and requirement to “guess” how your data will compress for the whole table. Among other things compression for data pages and uncompressed index pages can…we have 8 blobs 8xN bytes will be allocated) Question: How much…
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: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…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…
