… announcing XtraDB release 7. This is the last release based 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 as… located on http://www.percona.com/mysql/xtradb/5.1.37-7/ The latest source code of XtraDB, including development branch you can find…
Comment: XtraDB storage engine release 1.0.3-7
August 19, 2009 By 6 Comments
…-XtraDB-1.0.3-7-5.1.37-7.rhel5.x86_64.rpm file /usr/lib64/mysql/plugin/ha_innodb.so.0.0.0 from install of Percona-XtraDB-1.0.3-7-5.1.37-7.rhel5.x86_64 conflicts with file from package Percona-XtraDB-1.0.3-5-5.1.34… from install of Percona-XtraDB-1.0.3-7-5.1.37-7.rhel5.x86_64 conflicts with file from package Percona-XtraDB-1.0.3-5-5.1.34-5.rhel5…
Comment: XtraDB storage engine release 1.0.3-7
August 17, 2009 By 6 Comments
Is the Percona-XtraDB-1.0.3-7 rpm missing from the RPM binaries directory? http://www.percona.com/mysql/xtradb/5.1.37-7/RPM/rhel5/
Post: Percona testing: Quick test clusters with kewpie!
January 13, 2012 By Leave a Comment
…(sys.argv[0])) -#project_name = ‘percona-xtradb-cluster’ +project_name = ‘percona-xtradb-cluster’ #project_name =… from t1; +—-+ | a | +—-+ | 1 | | 4 | | 7 | | 10 | | 13 | +—-+ 5 rows in set (0.00 sec) mysql> …: server_requests = {‘join_cluster’:[(0,1), (0,2), (0,3)]} When you are done, you …
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
…/ is now available in our latest releases of XtraBackup 0.8.1 and XtraDB-6. Now I am going to show how to… binary builds with 5.1.36. On new server we run set global innodb_expand_import=1; to put XtraDB into extended import…: import: 2 indexes are detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…1.5 years ago: State of the art: Galera – synchronous replication for InnoDB. It was about the 0.7…1 and MariaDB 5.1. The latest is more interesting for us, as it is based on XtraDB. That means Galera supports the XtraDB… systems based on InnoDB/XtraDB. The recommended setup is 3 nodes and you can add…
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
…3) unsigned NOT NULL default ‘0‘, `is_adult` tinyint(3) unsigned NOT NULL default ‘0…=1, data=510 bytes, data/pages=3% level 1 pages…7 estimated statistics in dictionary: key vals: 330426, leaf pages 33889, size pages 38848 real statistics: level 2 pages: pages=1…this is in XtraDB/InnoDB plugin – fast …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…XtraDB. Requires m1.large or larger. ami-f65ea19f shard-query-infobright-demo i686 ICE 3…CREATE TABLE `dim_flight` ( `UniqueCarrier` char(7) DEFAULT NULL, `AirlineID` int(11)…_query Array ( [count(*)] => 135125787 ) 1 rows returned (0.084244966506958s, 0.078309059143066s, 0.0059359073638916s) Execute …
Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 13 Comments
…XtraDB…
Post: Maximal write througput in MySQL
February 28, 2010 By 10 Comments
…on: – durability setting ( innodb_flush_log_at_trx_commit = 0 or 1 ) ? – do we use binary logs ( I used …space and binary logs. And I used Percon-XtraDB-5.1.43-9.1 for benchmarks. All used partitions are …is 3086.7 tps. So this is good decision if binary log protection is worth such drop. UPDATE ( 3/…
