InnoDB compression is getting some traction, and I see quite contradictory opinions. Someone has successful deployments in productions, and someone says that compression… PowerEdge R900, running Percona-Server-5.1.57-rel12.8 (…0 97 1 0 7 0 93 0 0 7 0 93 0 0 7 0 93 0 0 7 0 93 0 0 7 0 93 0 0 7 0 93 0 0…
Post: Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance
April 29, 2009 By 12 Comments
…situation with Innodb is quite strange – leaving apart Innodb derivatives, like XtraDB there are 3 innodb versions around. There is MySQL 5.0 version which…is Innodb Plugin which has significant architectural changes such as new storage format, compression and fast index build. Innodb plugin 1.0.3 …
Post: Performance improvements in Percona 5.0.83 and XtraDB
July 14, 2009 By 27 Comments
… checkpoint activity, and we did not used innodb_adaptive_checkpoint in this case for XtarDB / 5.0.83-percona. And, by the way… that XtraDB, 5.0.83-percona and 5.4 are almost equal, with difference we have get some extra performance turning InnoDB readahead off…: – XtraDB is based on InnoDB plugin 1.0.3, with all its benefits like FAST INDEX CREATION, table compression – XtraDB will support moving…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… whole record R. Also, a gzip compression potentially compresses the database more than just prefix compression. The downside in gzip is increased usage…: Innodb Q: Is Group commit still busted in 5.0/5.1? HT: Yes. However, work has been done on it by Inaam. Q19: INNODB…: Users have reported lots of InnoDB scalability problems from multicore CPU’s. The most recent 5.0.xx behave better. We will continue…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… 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… make binaries with them available. With current MySQL 5.0 I still see Innodb having serious scalability problems in some environments with 4…
Post: Testing InnoDB "Barracuda" format with compression
April 23, 2008 By 3 Comments
…’ as compressed field, doing compress()/uncompress() to store/restore. To test InnoDB compression I use only uncompressed text, though I tested compression on compress()-ed data… from index compression. For test I use dump created with mysqldump, final size 30286M. To create InnoDB compression table I use ENGINE=InnoDB KEY… took 1.5 times longer than (case 1) ) size of final .ibd file for (case 3) – 16284M (space ratio is 0.37…
Post: Blob Storage in Innodb
February 9, 2010 By 13 Comments
… large Blob (and potentially compress it) If all columns do not fit to the page completely Innodb will automatically chose some of… 5.0 and above) format and the fix comes with Innodb Plugin in “Barracuda” format and ROW_FORMAT=DYNAMIC. In this format Innodb stores… specified and compression for normal data and index pages is not enabled. If you’re interested to learn more about Innodb row…
Post: xtrabackup-0.3, binaries and stream backup
March 13, 2009 By 11 Comments
… or with InnoDB also ? A: xtrabackup is designed to work with standard version of InnoDB in MySQL 5.0. MySQL 5.1 + standard InnoDB / InnoDB-plugin also are supported. It can fully work as drop-in replacement of innodbackup tool and InnoDB… missed in InnoDB Hot Backup – the backup can be produced as stream and copied to remote box or tape, or compressed without…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…an unimplemented feature degraded the performance when using compressed tables and has been removed (buf_LRU_… for those upgrading from MySQL 5.0 or 5.1 prior to version 5.1.24. A fix …be printed for the deprecated options (innodb_buffer_pool_shm_key and innodb_buffer_pool_shm_checksum) if…
Post: Great work Innodb Team
November 30, 2009 By 8 Comments
… Performance And Scalability. Innodb Plugin 1.0.4 had a lot of great performance improvements and 1.0.5/1.0.6 gets even further… the plugin during latest months. We can also see Innodb Plugin 1.0.5 is named Release Candidate which hopefully means it will… public release and probably 4 years since the work on Innodb plugin features such as compression or Online index creation has started.
