… 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
April 3, 2012 By 10 Comments
… 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: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… on SSD is : innodb_flush_neighbor_pages = 0 innodb_adaptive_flushing_method = keep_average innodb_log_block_size = 4096 innodb_log_file_size = 4G… is a way to improve throughput in Percona Server: increase innodb_log_file_size. There are stability timeline for Percona Server…, you can see that with a proper tuning, Percona Server/XtraDB outperforms MySQL, and provides a more stable throughput. Of course…
Comment: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… the same. It sounds to be correct, since MariaDB+vanilla Innodb (both based on 5.1 codebase) performed well 256 concurrent… MySQL5.5 On the other hand, everything based on XtraDB (PerconaServer 5.1, MariaDB+XtraDB) showed quite a slowdown in his results.
Comment: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
Could also briefly follow up XtraDB‘s 50% performance regression compared to Innodb, if XtraDB runs without specific tuning presented in this post? Just for my own understanding of numbers presented here http://blog.montyprogram.com/benchmarking-mariadb-5-3-4/ .
Comment: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… default “innodb_adaptive_checkpoint=estimate” It performs much more work than “innodb_adaptive_checkpoint=keep_average” and in the result XtraDB may be slower than MySQL/InnoDB-plugin, because it…
Post: XtraDB / InnoDB internals in drawing
April 26, 2010 By 4 Comments
I did some drawing exercise and put XtraDB / InnoDB internals in Visio diagram: The XtraDB differences and main parameters are marked out. PDF version is there http://www.percona.com/docs/wiki/percona-xtradb:internals:start.
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… tasks there. The goal of benchmarks was investigation of InnoDB-plugin and XtraDB scalability in CPU-bound load. CPU specification: processor : 23… MySQL-5.1.30 with InnoDB plugin, Xtradb-1.0.2-1, and XtraDB-1.0.2-2 (rel2). XtraDB-rel2 has not been… grows up to 16 connections, but after that InnoDB-plugin is dropping down. XtraDB and XtraDB-rel2 seem quite better, I guess this…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
… 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: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
…: 38530 InnoDB_IO_r_bytes: 631275520 InnoDB_IO_r_wait: 0.204893 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000 # InnoDB_pages… you cannot really control it (tough it is possible in XtraDB / InnoDB-plugin with FAST INDEX creation) so be careful with queries… you can use Innodb_scan_pages_contiguous ; Innodb_scan_pages_jumpy statistics in 5.0-percona releases (coming to 5.1-XtraDB soon)
