…_files_in_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb_flush_log_at_trx_commit = 2…_write_io_threads = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that…
Post: Percona XtraDB Cluster 5.5.20 - Beta release
February 23, 2012 By 10 Comments
… the recently released Galera 2.0 GA The main focus in this… Cluster provides: Synchronous replication. Transaction either commited on all nodes or none. Multi…group Launchpad project Bug reports Previous posts on this topic: Percona XtraDB Cluster Feature 1…’;fsb=’13′;bw=’100′;ff=’4‘;pc=’4889F0′;b=’…
Post: Innodb plugin 1.0.4 released - great job Innobase
August 11, 2009 By 3 Comments
… months after release of Innodb Plugin 1.0.3 (I honestly expected to see Innodb Plugin 1.0.4 to be released by MySQL Conference… fixed Group Commit Bug which I reported about 4 years ago and which was known for about 5 years, since early MySQL 5.0… starts – we need to evaluate/benchmark/stress test Innodb Plugin 1.0.4 to integrate it with next XtraDB release.
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
…_trx_commit=1 and sync_binlog=1 or in tabular format: Threads Nofix Group Commit fix 1 21.51 21.99 2 30.62 31.26 4… sync_binlog=0 and without write-back cache: Threads Nofix Group Commit fix 1 38.19 33.11 2 49.35 47.32 4 87… with group commit fix. Results with disabled write cache thread trx=1, No binlog trx=0, No binlog trx=1, Binlog sync=0 trx=1, Binlog sync=1 1…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… MySQL 4.1 to 5.0 upgrade notes ? ? Furthermore if there were no good ideas how to make XA to work with group commit why… have to have plenty of concurrent transactions so group commit would trigger in MySQL 4.0 and large number of transactions in total so… not get same performance as with MySQL 4.1 Disable Binary Logging This allows to get group commit back but obviously you loose point…
Post: Group commit and XA
May 19, 2006 By 8 Comments
Returning to post Group commit and real fsync I made several experiments: I ran sysbench …-bin —log-bin and —innodb_support-xa=0 1 1218.68 614.94 1010.44 4 2686.36 667.77 1162.60 16… 3630.55 665.18 1151.36 So we can see group commit is not only broken when XA is enabled but also…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…_log_at_trx_commit = 2 innodb_log_buffer_size = 128M innodb_log_file_size = 512M innodb_log_files_in_group = 2 innodb… 1.0.4“: Normal InnoDB Plugin 1.0.4 without XtraDB specific options “xtra p_t 0“: XtraDB 1.0.4-new (no purge_thread) “xtra p_t 1“: XtraDB 1.0.4-new (single purge_thread similar to Dimitri’s) “xtra p_t 4“: XtraDB 1.0.4…
Post: Great work Innodb Team
November 30, 2009 By 8 Comments
… Performance And Scalability. Innodb Plugin 1.0.4 had a lot of great performance improvements and 1.0.5/1.0.6 gets even further with long standing caching issues of large full table scan wiping off the cache. The Group Commit… plugin during latest months. We can also see Innodb Plugin 1.0.5 is named Release Candidate which hopefully means it will…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
…1.30 trees – MySQL 5.1.30 with standard InnoDB, MySQL 5.1.30 with InnoDB-plugin-1.0.2 and MySQL 5.1…_file_io_threads = 4 innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_file_size = 256M innodb_log_files_in_group = …
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
… total 15.0% 0.0% 9.5% 0.0% 0.3% 6.5% 68.4% cpu00 22.1% 0.0% 11.1% 0.1% 1.1% 6.1% 59.1% cpu01 14.9% 0.0% 7.5% 0.0% 0.0% 5.9% 71.5% cpu02 10.5% 0.0% 12.5% 0.0% 0.1% 7.1…_threads=4 innodb_lock_wait_timeout=15 # CHANGED from 50 innodb_log_files_in_group=3 innodb_flush_log_at_trx_commit=0 #innodb…
