… results for InnoDB vs InnoDB-plugin during runs (values are in new order transactions per minute, more is better) : As you see InnoDB-plugin is doing… NOTPM XtraDB-1.0.6-9 26160.551 NOTPM InnoDB-plugin is 1.6x times better InnoDB, and XtraDB is 1.7x times better InnoDB-plugin. Now…
Comment: Introducing percona-patches for 5.1
February 14, 2010 By 21 Comments
Kay, Yes, I compare to build-in InnoDB. If we spoke about InnoDB-plugin, then to compare apple to apple we need to compare InnoDB-plugin vs Percona-XtraDB. And some results you can see there http://www.mysqlperformanceblog.com/2010/01/13/innodb-innodb-plugin-vs-xtradb-on-fast-storage/
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 scan… you can use Innodb_scan_pages_contiguous ; Innodb_scan_pages_jumpy statistics in 5.0-percona releases (coming to 5.1-XtraDB soon)
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…, you can see that with a proper tuning, Percona Server/XtraDB outperforms MySQL, and provides a more stable throughput. Of course… it out, you always can fall back to the vanilla InnoDB-plugin, like MariaDB suggests in Benchmarking MariaDB-5.3.4. Raw…
Post: READ-COMMITED vs REPETABLE-READ in tpcc-like load
February 11, 2010 By 6 Comments
… poping up again and again. Recently it was discussed in InnoDB : Any real performance improvement when using READ COMMITED isolation level ? and in Repeatable read versus read committed for InnoDB . Serge in his post explains why READ COMMITED is better… replication in 5.1), and everything was run under XtraDB-9 ( based on InnoDB-plugin 1.0.6) So there are results: For…
Post: read_ahead (disabled) as steroid
May 12, 2009 By 4 Comments
… it is available as “hacks” to XtraDB (available on Lauchpad lp:~percona-dev/percona-xtradb/hacks-porting-tune if you are interested… XtraDB ? The most interesting reason is XtraDB based on InnoDB-plugin and contains its nice features like FAST INDEX CREATION and dynamic pages. And XtraDB… be included in 5.4 or InnoDB-plugin. For curiosity I run the same benchmarks on ext3 vs xfs on SSD card, the…
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
… are: Performance patches for InnoDB ®. Although many patches are present in XtraDB / InnoDB-plugin, the RC status of plugin does not allow to install it on product for some customer’s policies. Important fixes are: – InnoDB… tpce-like benchmark, where I compare MySQL-5.1.43 vs percona-5.1.43. The results made for TPCE configuration…
