…MySQL code and having them work on the application side as well which gives you best of both approaches. One…compressed data storage. Before going ahead with compression I usually run some checks to see how much compression…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…can write CSV files with any programming language. Naturally, CSV files don’t store as compactly on disk as [Compressed… takes one row, and an ad that gets one impression takes exactly the same: one …can be overcome, but how much time do you have? And the gains are simply limited by some of MySQL…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… server. As we can see here the one causing the highest load …the # MISC part, it tells you how much of “load” is not covered by…can use to gather more data about the underlying tables involved and the query execution plan used by MySQL…name column, or you might even compress the values stored in the …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…how your data will compress for the whole table. Among other things compression for data pages and uncompressed index pages can…Cool. This is one of little known new features in MySQL 5.1 Q15: How frequently does … 8xN bytes will be allocated) Question: How much space InnoDB allocates for each blob …
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… cache is great as it means it can have much more data cached in the same cache…We should however see how “compact” they would be in real world cases and how much performance it will… in MySQL anyway though). Very interesting to see how this one will compare to transparent gzip page compression …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…can‘t be compressed to specified page size and will have to consume more than one…. It is also rather interesting how is sort file structured for building … sorted so they should be much faster for IO Bound Index …from Google released so many MySQL patches so we can call patched version GoogleSQL…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
…MySQL Database most people compress them – which can…compressed file. This gives us compression speed of about 21MB/sec – clearly much less than even single SATA hard drive can…
Post: Trying Archive Storage Engine
November 12, 2006 By 6 Comments
… one of server used for web request profiling stats…mysql mysql 984628803 Nov 12 11:29 requests_061111.ARZ -rw-rw—- 1 mysql mysql 9162 Nov 12 11:00 requests_061111.frm Can…how much table would take if compressed with bzip2 – it took a while to compress but result was 310MB 40% better than compressed…
Post: The case for getting rid of duplicate “sets”
May 17, 2011 By 2 Comments
… process data in sets, which can be much faster than processing it serially…you distribute computation you work faster. How can we effectively reduce the data …one minus-two, at least two fifteens, etc select * from compressed join search_set using (val) where compressed.cnt >= search_set.cnt; mysql…
Post: Innodb row size limitation
April 7, 2011 By 11 Comments
…; Now you insert some test data into it: mysql> INSERT INTO example -> VALUES ( ->Â Â NULL, ->Â…code in a lot of places. How much you can win with this approach depends a lot…COMPRESS/UNCOMPRESS can yield great results. Finally, let me mention that handling of overflow pages involves other things one…
