… results for InnoDB vs InnoDB-plugin during runs (values are in new order transactions per minute, more is better) : As you see InnoDB-plugin… 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… on FusionIO) To summarize MySQL InnoDB/InnoDB-plugin/XtraDB is not fully able to utilize throughput of FusionIO. XtraDB is doing better job with…
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)
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
… most interesting patches are: Performance patches for InnoDB ®. Although many patches are present in XtraDB / InnoDB-plugin, the RC status of plugin… tpce-like benchmark, where I compare MySQL-5.1.43 vs percona-5.1.43. The results made for TPCE configuration… in InnoDB rw-lock implementations and in buffer_pool mutex contention, which alredy fixed in percona-patches ( and in XtraDB and InnoDB-plugin…
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…
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…
Post: read_ahead (disabled) as steroid
May 12, 2009 By 4 Comments
… may say what’s the reason in 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 has some… included in 5.4 or InnoDB-plugin. For curiosity I run the same benchmarks on ext3 vs xfs on SSD card, the…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…other issues we should look for? A: Percona XtraDB Cluster is a synchronous replication technology, therefore … successive queries. Q: Is RBR faster replicating vs SBR replication? RBR is faster than statement based,… using a write-through cache? A: The InnoDB buffer pool is effectively a type of …
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: PBXT in tpcc-like benchmark
June 2, 2010 By 10 Comments
… about 1.5x better XtraDB, but there periodical drops which are very similar to periodical drops in InnoDB without adaptive checkpointing, and… results are also better for PBXT: 5785.567 TpmC vs 4905.967 TpmC ( XtraDB) For 16 threads final result is: 26129.350 TpmC for PBXT and 29485.518 TpmC for XtraDB , and from the graph you can see that the maximal…
Comment: COUNT(*) for Innodb Tables
December 20, 2011 By 32 Comments
… servers and found some interesting results related to InnoDB count(). We’re using XtraDB(InnoDB by Percona) tables (version 5.5.14-rel20… if this is just more efficient for InnoDB/XtraDB, or if it’s due to the difference in field type (bigint vs int).
