…testing. InnoDB’s inbuilt row compression MySQL‘s inbuilt compress() function leveraging zlib to provide compression of data. MySQL‘s Archive storage engine. Tooling The …disk Engine Compression Ratio 7.1M Archive 173.07:1 304M InnoDB row_format=compressed key_block_size=4 4.04:1 648M compress() 1…
Post: Trying Archive Storage Engine
November 12, 2006 By 7 Comments
…compressed by gzip. I wish Archive storage engine would specify archiving method and compression level. Some people may like fast compression…compresses your data and should be good for log storage or storing something which needs no updates and no indexes, however compression ratio…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
…. Also note the serious leap in compressed file size. Though in this example we used MySQL binary log file which often contains… size difference based on compression ratio. The decompression takes about same 10 seconds which gives about 32MB/sec of archive read speed and… generated with 13 MB/sec. For all archivers it is possible to use parallel compression to get better speed though this also…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…, top ads by clicks, top ads by click-through ratio, and so on for dozens of different types of… don’t store as compactly on disk as [Compressed] MyISAM or Archive. These are just some ideas I’m throwing … that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing …
Comment: Adventures in archiving
February 13, 2013 By 16 Comments
… awhile myself, archiving syslog into mysql. Archive wasnt a solution cause of indexing. Daily packing myisam tables worked but not very good compression, and… it on solaris and used gzip filesystem compression on it, getting a good 10:1 ratio currently. I dont notice any spead…
Post: Living with backups
November 6, 2008 By 28 Comments
… by random “garbage” for no good reason. Since the hit ratio becomes worse as the cache is being filled with random…, create a compressed archive. For example: /root/backup-tools/tar –read-rate=15000000 -C /mnt/snapshot -c -z -v -f – mysql | ssh backup… script sends CONT signal which resumes archiving. The levels are of course different for every MySQL instance, these are just examples. The…
