May 24, 2012

Comment: Benchmarking single-row insert performance on Amazon EC2

… free’ed again. XtraDB lets you accelerate the rate at which insert buffer pages are flushed to disk (innodb_ibuf_accel_rate… insert buffer flushing was enabled (using the FB patch, not XtraDB but difference should be similar)

Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release

… of the GA release of our new product Percona XtraDB Cluster. Percona XtraDB Cluster is a High Availability and Scalability solution for… required to start work with Percona XtraDB Cluster Percona XtraDB Cluster is based on Percona Server with XtraDB and includes Write Set REPlication….1-beta2 State of the art: Galera – synchronous replication for InnoDB Happy clustering! mbgc=’f5f5f5′;ww=’320′;mbc=’cecece’;bbc=’3F79D5…

Post: Looking for InnoDB/XtraDB hacker

InnoDB/XtraDB code we invite you to join our development team to work on the following (but not limited to) problems: Fix InnoDB…/09/18/disaster-mysql-5-5-flushing/ Fix InnoDB index locking Figure out InnoDB adaptive locking issue, e.g: http://www.mysqlperformanceblog…-biggest-innodb-problems/ Make some InnoDB tables non-transactional :) Make InnoDB page size setting per tables and per index Specify location of InnoDB tables…

Post: XtraDB storage engine release 1.0.3-6

… checkpoint method estimate innodb_stats – the implementation of the fix forMySQL Bug#30423 expand-import Support of import InnoDB / XtraDB tables from another… in Percona-XtraDB: “main.innodb_xtradb_bug317074 internal check fails on 5.1.36” Bug #395778 in Percona-XtraDB: “main.innodb-analyze internal…

Post: Impossible - possible, moving InnoDB tables between servers

… XtraBackup, now it can copy and prepare InnoDB/XtraDB tables, which later can be imported into XtraDB. To be objective the process is… on source. (on destination you should have XtraDB with innodb_expand_import extension and with innodb_expand_import=1 setting) 4) run alter… XtraDB innodb_expand_import available only in source code for now, you can get them from Launchpad projects https://launchpad.net/percona-xtradb

Post: Video: The InnoDB Storage Engine for MySQL

… on Vimeo. It relates to InnoDB built-in and InnoDB plugin.  I left out Percona Server and XtraDB for simplicity. If you… day course on InnoDB/XtraDB, the talk “Introduction to the InnoDB Storage Engine for MySQL” (Morgan Tocker) at Collaborate, “Innodb and XtraDB Architecture and Performance…

Post: Fix of InnoDB/XtraDB scalability of rollback segment

… 10 on 8 disks) to compare mysql-5.1.30-XtraDB-1.0.2-pre-release3 with default (1) and 16… innodb_buffer_pool_size=6G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=128M innodb_thread_concurrency=0 innodb_extra_rsegments…

Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!

Innodb/XtraDB tables do benefit from being reorganized often. You can get … to do it. If you’re running Innodb Plugin on Percona Server with XtraDB you get benefit of a great new feature…(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `c` (`c`) ) ENGINE=InnoDB AUTO_INCREMENT=12582913 DEFAULT CHARSET=latin1 mysql> select * from a…

Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB

… storage engine, “Percona XtraDB“, which is based on the InnoDB storage engine. It’s 100% backwards-compatible with standard InnoDB, so you can… forked from InnoDB-plugin-1.0.2. Percona XtraDB is released under GPL v2, as is InnoDB-plugin base source code. Percona XtraDB is… will also be using Percona XtraDB for its upcoming 5.1 builds. XtraDB is fully compatible with existing InnoDB tables and we are…

Post: XtraDB: The Top 10 enhancements

… configuration items for innodb_read_threads, innodb_write_threads (see docs). Better Diagnostics – The SHOW ENGINE INNODB STATUS command in XtraDB shows a lot… In a simple test, XtraDB recovered ten times faster (see docs). InnoDB Plugin Features – XtraDB is derived from the InnoDB plugin, which has fast…