…. Also, a gzip compression potentially compresses the database more than just prefix compression. The downside in gzip is increased usage of CPU time. PZ: We… here? INNODB was originally written on single core CPUs. HT: Users have reported lots of InnoDB scalability problems from multicore CPU‘s. The…
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
… responsible for 90% of space usage hence compressing only externally stored blobs …innodb_file_format=BARRACUDA; One caveat: you must be running with innodb_file_per_table=1 as the InnoDB system tablespace cannot be compressed…was bound to a single CPU while compressing the data. Just have patience…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… pool usage (currently you may need to both store Compressed and …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…increasingly important as their number per CPU just keeps doubling. It …
Post: How network can impact MySQL Operations ?
September 1, 2008 By 5 Comments
… RAID is powerful enough. This applies to large Innodb tables with not overly fragmented tablespace, or it … can get even better with using fast parallel compression like LZO or QuickLZ but there was no …sec instead of projected 80MB/sec. The IO and CPU usage both on source and target servers was low …
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…InnoDB / MyISAM. Actually in internal cache records are stored in uncompressed form, but OS Cache can keep compressed… TokuDB outperforms InnoDB 1.4-2.5x times, but CPU-bound is not…InnoDB will be included in a future release. With all the given advantages and drawbacks, I see a good practical usage…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
…CPU cores if needed. In previous versions, compression was only possible with streaming backups + external (usually single-threaded) compression… XtraBackup against debug versions of InnoDB. This is only for very … around it: Percona XtraBackup: install, usage, tricks tutorial, Tuesday 10th April …
Comment: Blob Storage in Innodb
February 17, 2010 By 13 Comments
…) A single large file in the filesystem for that 1 InnoDB table that holds the blob. Queries against this table will… disk space usage is important, use row compression and pay the CPU price on your DB server, or have your application compress/decompress upon…
Post: Living with backups
November 6, 2008 By 28 Comments
…, on the fly, create a compressed archive. For example: /root/backup-tools…… Please cosult ionice man page for usage details, it’s really very …it’s always the case for InnoDB tablespaces, other MySQL data files … include things like processlist information, CPU load avergages, I/O load, etc…
