… based allocation is used. Q18: Innodb Q: Is Group commit still busted in 5.0/5.1? HT: Yes. However, work has been done… that mutex from 5.1, then InnoDB’s group commit works again. PZ: You can disable binary logging to get Group Commit back. Though this… going to be common place. We’re considering buying 40 8-core boxes with 32G of memory. Have any specific thoughts…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… are the results of my testing of the new Group Commit in Percona Server 5.1. As background information, the problem appears when… two versions tested: Percona Server 5.1.57 – released and Percona Server 5.1.57 with the Group Commit Fix applied. The first graph…: Threads Nofix Group Commit fix 1 352.83 371.17 2 682.41 676.39 4 1265.79 1288.49 8 2319.12…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…0000-0000-000000000000) does not match group state UUID (77c9da88-b965-11e1-0800…usr/sbin/mysqld: ready for connections. Version: ‘5.5.24-log’ socket: ‘/var/lib/mysql… but because of optimistic locking at commit time, rollbacks can happen if …oltp-table-size=10000 –num-threads=8 run This is the status…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
In my post MySQL 5.5.8 and Percona Server: being adaptive I mentioned that I used …, and run tpcc-mysql benchmark with 500W using Percona Server 5.5.8. Here is relevant part of config what I used innodb… innodb_flush_log_at_trx_commit=2 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… part. Benchmark date: Oct-2012 Benchmark goal: Test how MySQL 5.6.7 performs Hardware specification Server: Dell PowerEdge R710 CPU… the result significantly, especially in intensive IO workloads. In MySQL 5.6 it is finally possible to achieve stable throughput without…_trx_commit = 1 innodb_buffer_pool_size = 125G innodb_buffer_pool_instances=8 innodb_log_file_size = 4G innodb_log_files_in_group…
Post: Adaptive flushing in MySQL 5.6
September 4, 2012 By 8 Comments
…://www.mysqlperformanceblog.com/2011/01/03/mysql-5-5-8-in-search-of-stability/ In MySQL 5.6 there was implemented a new flushing…’s see what the result we are getting in MySQL 5.5 ( MySQL 5.5.27): As you can see there is prolonged periods…_log_at_trx_commit = 2 innodb_buffer_pool_size = 150G innodb_log_file_size = 4G innodb_log_files_in_group = 2 #####plugin…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… support to DBQP. For 5.1: mtr-helgrind-51.patch For 5.5: mtr-helgrind-55.patch …8 by thread #1 ==9090== at 0x6BC9FFF: mutex_spin_wait (sync0sync.c:441) ==9090== by 0x6B751FC: mtr_commit…_io (fil0fil.c:4432) ==9090== by 0x6B67EDA: log_group_write_buf (log0log.c:1290) ==9090== by 0x6B68496…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…file_path = ibdata1:10M:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size…size = 64M innodb_log_files_in_group = 2 innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 200 port…1 34.1 7.7 0% 3.8 8.2 12.1 87.0 0.5 0% 0.0 0.7 93% 0…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE transaction-isolation = READ-COMMITTED… = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output …:autoextend innodb_file_per_table innodb_log_group_home_dir = /log/mysql/var/ innodb_checksums …
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
… of memory 26 EC2 Compute Units (8 virtual cores with 3.25 EC2 Compute…. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following …group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb_flush_log_at_trx_commit…
