…/impossible-possible-moving-innodb-tables-between-servers/ is now available in our latest releases of XtraBackup 0.8.1 and XtraDB-6. Now…, no needs to lock or shutdown server. To export table you need XtraBackup, and you can just specify table or table by mask: xtrabackup… global innodb_expand_import=1; to put XtraDB into extended import mode, and now we need to create empty table with the same table…
Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 13 Comments
… just OPTIMIZE TABLE might not be best way to do it. If you’re running Innodb Plugin on Percona Server with XtraDB you… it is OK table is exposed without indexes for some time. Note though nothing stops you from using LOCK TABLES on Innodb table to ensure there is not ton of queries starting reading table with no indexes and…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
…INNODB STATUS. We’ve added more memory information and lock information, and fixed problems with lock information. documentation Improvements to InnoDB IO. Improvements of InnoDB…also be using Percona XtraDB for its upcoming 5.1 builds. XtraDB is fully compatible with existing InnoDB tables and we …
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… MySQL-5.1.30 with InnoDB plugin, Xtradb-1.0.2-1, and XtraDB-1.0.2-2 (rel2). XtraDB-rel2 has not been…=4 innodb_additional_mem_pool_size=16M innodb_buffer_pool_size=15G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush… that InnoDB-plugin is dropping down. XtraDB and XtraDB-rel2 seem quite better, I guess this is mostly because fixes to rw_locks and…
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
…InnoDB Table has 11864696 rows and takes Data_length: 698,351,616 bytes on disk The problem is that after restoring table…InnoDB_IO_r_bytes: 631275520 InnoDB_IO_r_wait: 0.204893 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000 # InnoDB…it is possible in XtraDB / InnoDB-plugin with FAST …
Post: Looking for InnoDB/XtraDB hacker
October 25, 2011 By 3 Comments
… InnoDB/XtraDB code we invite you to join our development team to work on the following (but not limited to) problems: Fix InnoDB…/25/index-lock-and-adaptive-search-next-two-biggest-innodb-problems/ Make some InnoDB tables non-transactional 
Make InnoDB page size setting per tables and per…
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
… MyISAM table lock behavior in your applications, also check if your application handled deadlocks well. MyISAM will not produce deadlocks for Innodb you… chunks, almost row by row to avoid holding table lock for long time in Innodb you want larger updates to reduce cost of…, you do not want to try to run Innodb or XtraDB with them. Second Innodb is tuned to be ACID by default – if…
Post: XtraDB storage engine release 1.0.3-5
April 28, 2009 By 8 Comments
… MySQL 5.1.34 removed rw_lock patch, so we now use Google’s rw_locks fix crash after upgrade 5.1.31 -> 5.1.33 fix mysql-test Percona XtraDB 1.0.3-5 available in source and several binary packages. XtraDB is compatible with existing InnoDB tables (unless you used innodb_extra…
Post: XtraDB storage engine release 1.0.2-3 (Spring edition) codename Sapporo
March 2, 2009 By 10 Comments
…_hash read-write lock. See benchmark results. Fix broken group commit in InnoDB As you know, the group commit of InnoDB doesn’t… Percona XtraDB 1.0.2-3 (Sapporo) available in source and several binary packages. XtraDB is compatible with existing InnoDB tables (unless you used innodb…
Post: XtraDB storage engine release 1.0.3-4 codename Sakura
April 8, 2009 By 9 Comments
… rw_lock patch Percona XtraDB 1.0.3-4 (Sakura) available in source and several binary packages. XtraDB is compatible with existing InnoDB tables (unless you used innodb…
