… amazing MySQL manual, especially the option and …commanual defaults_fileblogpercona.commanual defaults_group_suffixblogpercona.commanual delay_key_writeblogpercona…commanual innodb_checksumsblogpercona.commanual innodb_commit_concurrencyblogpercona.commanual innodb_concurrency_ticketsblogpercona…
Post: What is innodb_support_xa?
March 2, 2011 By 3 Comments
… internal XA coordination between the InnoDB transaction logs and the MySQL binary logs, to ensure that they are consistent. Consistent is… occurred when the commit process was changed to an internal XA implementation. This did two things: it disabled group commit, and it added an extra fsync per commit. The extra fsync is required because during…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
…_bin. Innodb tables also have to flush logs on transaction commit unless you disable it so you should not be getting… out for MySQL 5.0 – if you enabled Binary log with MySQL 5.0 you loose group commit which can dramatically increase commit rate for… single stream so group commit can’t work. Furthermore even if you run with innodb_flush_logs_at_trx_commit=2 you still…
Post: Percona and the MariaDB Foundation
December 19, 2012 By 3 Comments
… Percona Supports MariaDB. We support all variants and flavors of “MySQL” – Oracle MySQL, MariaDB, Drizzle, Percona Server, Amazon RDS – helping our customers… storage engine – our enhanced variant of Innodb. Percona Server includes Group Commit code from MariaDB. In the future we will continue to…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places… time-based types, as well as microseconds in SHOW PROCESSLIST Group commit for the binary log makes the server much faster with… same group commit fix, and MySQL 5.6 offers microsecond timestamp support, as well as a lot of optimizer improvements. Even the standard MySQL…
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
… adds more fsync calls, and causes mutex contention, and prevents group commit, and probably other things that aren’t coming to mind… series of posts on group commit alone. I think that a full fix might require significant architectural changes to MySQL. This will be… transaction logs, so there’s even precedent for this among MySQL storage engines. And there is Galera’s multi-master synchronization…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… managing a lot of relatively small MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding or replication IO… on commit too. MySQL also has broken group commit (which we have partial fix for) meaning concurrent transaction commits will need to be serialized. Second, MySQL…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…does not need much introduction, especially to the MySQL server developers. The Valgrind Memcheck tool, … (log0log.c:330) ==9090== by 0x6B75144: mtr_commit (mtr0mtr.c:153) ==9090== by 0x6BD7F87: trx… (fil0fil.c:4432) ==9090== by 0x6B67EDA: log_group_write_buf (log0log.c:1290) ==9090== by…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… have much support from MySQL to do so. What is really bad is Parallel query. Reporting with group by over 10.000… XA which were released in MySQL 5.0 without consistent work with MySQL close Partner – Innobase to ensure Group Commit still works in 5… inside who can figure things out and even patch MySQL if needed. So MySQL went to chase Enterprise market and develop enterprise…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
…. (Yasufumi Kinoshita) Old system variable innodb_enable_unsafe_group_commit was deleted. The existing MySQL variable innodb_support_xa can be used instead….7 could crash the server. (Yasufumi Kinoshita) MySQL bugs 56433 and 51325 – These MySQL bugs have been fixed in Percona Server. (Yasufumi…
