…-write lock. See benchmark results. Fix broken group commit in InnoDB As you know, the group commit of InnoDB doesn’t work after… this. New parameters in the XtraDB io patches: innodb_ibuf_max_size — Restrict innodb-insert-buffer size innodb_ibuf_active_contract — Enabling… 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.2-3 (Spring edition) codename Sapporo
March 2, 2009 By 10 Comments
Post: XtraDB: The Top 10 enhancements
August 13, 2009 By 5 Comments
… configuration items for innodb_read_threads, innodb_write_threads (see docs). Better Diagnostics – The SHOW ENGINE INNODB STATUS command in XtraDB shows a lot… In a simple test, XtraDB recovered ten times faster (see docs). InnoDB Plugin Features – XtraDB is derived from the InnoDB plugin, which has fast… application (this can be seen in any benchmark – such as this one). Â In XtraDB, adaptive checkpointing can smooth out the load…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… problems: A Real High Availability solution for systems based on InnoDB/XtraDB. The recommended setup is 3 nodes and you can add… to have performance numbers I am going to run different benchmarks, I expect that for simple master-slave setups the response… misunderstanding: Galera does work with InnoDB-plugin also. You may try also MariaDB/Galera based on XtraDB, but it is only available…
Post: Percona testing: Quick test clusters with kewpie!
January 13, 2012 By Leave a Comment
… INFO basedir: /percona-xtradb-cluster 20120113-125552 INFO clientbindir: /percona-xtradb-cluster/client 20120113-125552 INFO testdir: /percona-xtradb-cluster/kewpie 20120113-125552…-storage-engine: innodb 20120113-132229 INFO Using testing mode: cleanup 20120113-132229 INFO Killing pid 17040 from /percona-xtradb-cluster/kewpie/workdir…
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
… Innodb as well as searching the blog – We’ve blogged so much on this topic. So what are the basics ? Regression Benchmarks… hard to guaranty you will never run into them. Performance Benchmarks – Innodb and MyISAM have different performance properties and you can’t…, you do not want to try to run Innodb or XtraDB with them. Second Innodb is tuned to be ACID by default – if…
Post: Maximal write througput in MySQL
February 28, 2010 By 10 Comments
… amount transactions per second we can get using MySQL and XtraDB / InnoDB storage engine if we have high-end server. Good questions… would not take these as variable parameters and run simple benchmark. I took sysbench update_key scenario ( update indexed field on… for innodb log files, innodb system table space and binary logs. And I used Percon-XtraDB-5.1.43-9.1 for benchmarks. All…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… tasks, much like InnoDB. However, PBXT’s log-based architecture makes performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT’s performance is similar to InnoDB but, depending on your database… Is this the case, and do you have any recent benchmarks available? This is no longer necessarily the case. For example…
Post: Improving InnoDB recovery time
July 7, 2009 By 12 Comments
… tpcc-mysql benchmark with 16 running threads. MySQL params are: innodb_buffer_pool_size=16G innodb_log_files_in_group=3 innodb_log_file… 12 mins to start. In XtraDB we made some improvements, and it shows: 090706 17:04:11 InnoDB: Database was not shut… small, I would ask InnoDB experts to review it: http://bazaar.launchpad.net/~percona-dev/percona-xtradb/recovery-speed-hack/revision/86…
Post: 5.4 in-memory tpcc-like load
May 1, 2009 By 11 Comments
… my benchmarks http://www.mysqlperformanceblog.com/2009/04/30/looking-on-54-io-bound-benchmarks/ on … dips – all of them are caused by InnoDB checkpoint activity, InnoDB is doing intensive flushing of buffer_… of time in all user processes. In XtraDB we have special mode adaptive_checkpoint, you …
Post: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
… just changing cfq to noop solved their InnoDB IO problems. I ran tpcc scripts against XtraDB on our Dell PowerEdge R900 server… is graph of disk writes (column bo in vmstat) during benchmark As you see noop / deadline can utilize disks much better… used next XtraDB params: [mysqld] #mysqld options in alphabetical order user=root default_table_type=MYISAM innodb_buffer_pool_size=3G innodb_data…
