May 25, 2012

Post: MySQL Users Conference - Innodb

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)

…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

… 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

…_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

…, 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 Compressedcompressed 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

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

… 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

Innodb plugin and named “Antelope” in Innodb Plugin and XtraDB) Innodb would try to fit the whole row onto Innodb page. At least 2compress 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

InnoDB also ? A: xtrabackup is designed to work with standard version of InnoDB in MySQL 5.0. MySQL 5.1 + standard InnoDB / InnoDBInnoDB Hot Backup – the backup can be produced as stream and copied to remote box or tape, or compressed

Post: Great work Innodb Team

…. Innodb plugin documentation now seems to be merged with MySQL Documentation which makes it much more usable and Innodb Plugin is shipped with MySQL 52 years from the date of initial public release and probably 4 years since the work on Innodb plugin features such as compression