… prepare InnoDB/XtraDB tables, which later can be imported into XtraDB. To be objective the process is still not so easy as with MyISAM… 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: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
… 10 on 8 disks) to compare mysql-5.1.30-XtraDB-1.0.2-pre-release3 with default (1) and 16…=MYISAM 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…-user user –mysql-password –mysql-db sbtest –mysql-table-engine innodb –myisam-max-rows 1000000 run
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… would I use PBXT instead of a storage engine like MyISAM, InnoDB or XtraDB? Unfortunately it is not possible to point to a… performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT’s performance is similar to InnoDB but, depending on your database…
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
… on migrating MyISAM to Innodb or some other reason but recently I see a lot of questions about migration from MyISAM to Innodb. Webinar… to run Innodb or XtraDB with them. Second Innodb is tuned to be ACID by default – if you’re moving from MyISAM often you… data in MyISAM. The 3 most important values to check are innodb_flush_log_at_trx_commit, innodb_buffer_pool_size and innodb_log…
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…=MYISAM ft_min_word_len=4 innodb_additional_mem_pool_size=16M innodb_buffer_pool_size=15G innodb_data_file_path=ibdata1:10M:autoextend innodb… grows up to 16 connections, but after that InnoDB-plugin is dropping down. XtraDB and XtraDB-rel2 seem quite better, I guess this…
Post: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
… used next XtraDB params: [mysqld] #mysqld options in alphabetical order user=root default_table_type=MYISAM innodb_buffer_pool_size=3G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit=1 innodb…
Post: Doing Re-run of Migrating MyISAM to Innodb Webinar
December 1, 2010 By 9 Comments
… what happened to me). As result we have scheduled Migrating MyISAM to Innodb webinar to run again on Tuesday, December 7 at… register. Note we also Webinar on Percona Server, Xtrabackup and XtraDB next week which is great if you would like to…
Post: Webinar: Introduction to Percona Server, XtraDB and Xtrabackup
November 26, 2010 By 2 Comments
… had such a large number of signups to our Migrating MyISAM to InnoDB webinar, that we decided to hold one more before… is out: December, 8th 9AM PST: Introduction to Percona Server, XtraDB and Xtrabackup. As the title suggests: this presentation is an…
Post: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 24, 2009 By 20 Comments
… and so we can’t ensure it will support all XtraDB features – extra undo slots, rollback segments etc. After considering all… will use same backup approach as InnoDB Hot Backup, that is taking online copy of InnoDB table files and transactional logs. This is going to be fully OpenSource, GPL licensed backup solution for MySQL (MyISAM and InnoDB…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… point: Use InnoDB Assuming that you will use the stock MySQL server, InnoDB is usually your best bet. (Actually, XtraDB might be very… to the cost of repairing huge MyISAM tables and taking downtime, I would not use MyISAM for anything but read-only tables…’s read-only, there’s still another reason to use InnoDB/XtraDB tables… Optimize For I/O It is pretty much inevitable…
