…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… which may come in MySQL 5.2 or even MySQL 5.1. I surely would… available. With current MySQL 5.0 I still see Innodb having serious scalability…
Post: Innodb Caching (part 2)
May 10, 2011 By 7 Comments
…more space with 4K pages – 2.7GB instead of 2.2GB because of larger overhead. …Compression results come as a huge disappointment. The compressed .idb file was only 620MB so if Innodb would chose to keep only compressed… results for 16K and 16K Compressed to be very similar on MySQL 5.5 As a summary: …
Post: Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance
April 29, 2009 By 12 Comments
… 3 innodb versions around. There is MySQL 5.0 version which did not get significant changes for around 2 years now. There is Innodb Plugin which has significant architectural changes such as new storage format, compression and fast index build. Innodb…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…_CUR_PAGE_COMPRESS_LIMIT (UNIV_PAGE_SIZE / 2) Q5: When Innodb free space becomes available for use within same object? When does Innodb make… little known new features in MySQL 5.1 Q15: How frequently does Innodb fuzzy checkpointing is activated HT: InnoDB flushes about 128 dirty pages…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
…, running Percona-Server-5.1.57-rel12…uniform –max-time=1800 –mysql-user=root –…2 0 0 85 13 2 0 0 85 13 1 0 0 85 13 2 0 0 Compressed…compressed tables CPU utilization is 7%. Obviously we have some mutex serialization problem. Analyzing SHOW INNODB STATUS (SEMAPHORES) for workload with compression…
Post: Percona XtraBackup 1.6.3
September 23, 2011 By 5 Comments
…compressed InnoDB tables due to missing support for compressed pages in tar4ibd. Bug Fixed: #665210 (Alexey Kopytov). XtraBackup failed when innodb…regression introduced in XtraBackup 1.6.2, innobackupex –copy-back did not… MySQL 5.5 or Percona Server 5.5 prior to version 5.5.11. 5.1 releases from 5….
Post: InnoDB page sizes: plans and ideas
April 21, 2011 By 8 Comments
… needed ? For InnoDB compression. Right now if you use 16K and trying to compress, the only good choice is to compress to 8K pages (which gives you only 2:1 compress ratio), and you… InnoDB really flexible for different type of use cases and storage. As Oracle makes a lot of new good features in MySQL 5…
Post: Blob Storage in Innodb
February 9, 2010 By 13 Comments
…Innodb plugin and named “Antelope” in Innodb Plugin and XtraDB) Innodb would try to fit the whole row onto Innodb page. At least 2… compress it) If all columns do not fit to the page completely Innodb will…MySQL 4.1 and below) and COMPACT (MySQL 5.0 and above) format and the fix comes with Innodb…
Post: xtrabackup-0.3, binaries and stream backup
March 13, 2009 By 11 Comments
…InnoDB also ? A: xtrabackup is designed to work with standard version of InnoDB in MySQL 5.0. MySQL 5.1 + standard InnoDB / InnoDB…InnoDB Hot Backup – the backup can be produced as stream and copied to remote box or tape, or compressed…
Post: Great work Innodb Team
November 30, 2009 By 8 Comments
…. Innodb plugin documentation now seems to be merged with MySQL Documentation which makes it much more usable and Innodb Plugin is shipped with MySQL 5… 2 years from the date of initial public release and probably 4 years since the work on Innodb plugin features such as compression…
