… you might know, records inside an InnoDB page are organized in an…-5f pages-actor/FIL_PAGE_INDEX/0-1599/00000000-00000003.page -V … records: (200 200) 000000001917 DB000001720110 actor 1 “PENELOPE” “GUINESS” “2006-02-15…15 04:34:33″ 000000001917 DB000001720131 actor 4 “JENNIFER” “DAVIS” “2006-02-15 04…
Post: Innodb plugin 1.0.4 released - great job Innobase
As you might have seen Innodb Plugin 1.0.4 was released today. I am very excited to see this … exactly 5 months after release of Innodb Plugin 1.0.3 (I honestly expected to see Innodb Plugin 1.0.4 to be released by MySQL Conference… fun part starts – we need to evaluate/benchmark/stress test Innodb Plugin 1.0.4 to integrate it with next XtraDB release.
Post: XtraDB storage engine release 1.0.4-8
… on 1.0.4 version of InnoDB plugin. We thank Schooner Information Technology for sponsoring and testing the port of XtraDB to 1.0.4 MySQL 5.1… are located on http://www.percona.com/mysql/xtradb/5.1.39-8/ The latest source code of XtraDB, including development… run # apt-get update # apt-get install mysql-server-5.1 Please report any bugs found on Bugs in Percona XtraDB…
Post: XtraDB storage engine release 1.0.6-9
… new features: The release is base on 1.0.6 version of InnoDB plugin. MySQL 5.1.42 as a base release Separate purge… inconsistent with mysqld Bug #495342: “MySQL 5.1.41 + InnoDB 1.0.6 + XtraDB patches extensions-1.0.6, rev. 127 fails to compile on… builds for RedHat 4, 5 , Debian and Ubuntu are located on http://www.percona.com/mysql/xtradb/5.1.42-9/ . Since…
Post: XtraDB storage engine release 1.0.3-7
… on InnoDB plugin version 1.0.3, as you might know Innobase has released 1.0.4. The release includes following new features: MySQL 5.1.37…_list controlled by the new variable innodb_fast_recovery Fixed bugs: MySQL Bugs: #45357: 5.1.35 crashes with Failing assertion: index… flush again when innodb_flush_neighbours=0†Bug #395783 in Percona-XtraDB: “main.innodb_bug42101 fails on 5.1.36†This fixes…
Post: XtraDB storage engine release 1.0.3-4 codename Sakura
… release 1.0.3-4 of our XtraDB storage engine. Here is a list of enhancements in this release: Move to MySQL 5.1.33 Move to InnoDB plugin 1.0.3 more reliable replication, innodb_overwrite_relay_log_info patch now… XtraDB 1.0.3-4 (Sakura) available in source and several binary packages. XtraDB is compatible with existing InnoDB tables (unless you used innodb_extra…
Post: Great work Innodb Team
… which is 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 with… the plugin during latest months. We can also see Innodb Plugin 1.0.5 is named Release Candidate which hopefully means it will… the date of initial public release and probably 4 years since the work on Innodb plugin features such as compression or Online…
Post: Percona XtraBackup 1.6.4
Percona is glad to announce the release of Percona XtraBackup 1.6.4 on 19 December, 2011 (Downloads are available here and…, Percona Server 5.1.59-13.0 and Percona Server 5.5.16-22.0 and get all the InnoDB bug fixes each of… fix, innobackupexnow safely ignores file not found errors for non-InnoDB tables. Bug Fixed: #859546 (Lachlan Mulcahy) When the –incremental and…
Post: xtrabackup-0.9.5rc
… 0.9.5rc is available. In this release there are following changes: Changelog: Option –no-lock is added to innobackupex-1.5.1. Use it only while ALL your tables are InnoDB and you DO NOT CARE about binary log position of backup XtraBackup is ported for InnoDB Plugin 1.0.4. Barracuda file…
Post: Tuning InnoDB Concurrency Tickets
…=InnoDB; — 0 Tickets Used Query OK, 0 rows affected (0.36 sec) mysql> INSERT INTO test_table (id) values (1); — 0 Tickets Used Query OK, 1 row… CASCADE -> ) ENGINE=INNODB; — 0 Tickets Used Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO parent (id) VALUES (1),(2),(3),(4); — 3 Tickets…_id`) VALUES (1,1), (1,2), (2,1),(2,2); — 3 Tickets Used Query OK, 4 rows affected (0.01 sec) Records: 4 Duplicates: 0 Warnings: 0 So, how…

