…InnoDB with LOAD DATA INFILE. The goal was to load this data on many servers without putting it into the binary log…purged, row versions. Later, the purge thread will have to clean these up. This is how you make InnoDB…/tmp/my-fifo ]; do time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set …
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
… improvements available in MySQL 5.6 which …Innodb data file extension – Non-Recursive Deadlock Detection – Faster Locking Primitives – Improved Innodb Thread Concurrency – Multiple background Purge Threads – Improved Purge… Binary Log – Fight Cache Coherence and False Sharing issues – Reduced Innodb …
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… available here and from the Percona Software Repositories). Based on MySQL 5.1.66, including all the bug fixes in it…). Log tracking was initialized too late during the InnoDB startup. Bug fixed #1076892 (Laurynas Biveinis). Temporary files created by binary log cache were not purged…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…MySQL – Innodb. Innodb Storage Engine was covered in a lot of talks, many of them done by Innodb…MySQL 5.0+ Heikki also mentioned there are more things inside Innodb to unleash performance such as multiple purge threads or parallel log…
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
…innodb_flush_log_at_trx_commit_session – Implements a session-level version of the MySQL global system variable innodb_flush_log… maximum purge delay defined by innodb_max_purge_lag by removing the requirement that purge …€ rather than “InnoDB†The binary packages are available on our website…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…. For the initial tests, IÂ used MySQL 5.5.8 (the tar.gz binary from dev.mysql.com), and for the other tests… innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_read_io_threads = 16 innodb_write_io_threads = 16 innodb_purge_threads=1 innodb_adaptive_flushing=1 innodb…
Comment: Benchmarks of new innodb_flush_neighbor_pages
July 3, 2012 By 8 Comments
…questions/1568/clarification-on-mysql-innodb-flush-method-variable/1575#1575 Even though mysql 5.6 … Kernel Mutex, Multi-Threaded Purge, Separate Flush Thread, Pruning the InnoDB Table Cache This article …binary-log-file-size-matters/ [Quote] “Here’s what we did: we have reduced the size of binary log…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
…BINARY DATA… 080703 23:46:16 InnoDB: Page checksum 587461377, prior-to-4.0.14-form checksum 772331632 InnoDB…innodb_force_recovery modes to block purging activity, insert buffer merge or recovery from transactional logs…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_changes_in_mysql , in documentation now at http://dev.mysql.com/doc/…innodb_purge_batch_size is a performance enhancement, Should also be used in 5.5 to reduce purge overhead. innodb…innodb checksums in hardware, that 5.5 doesn’t understand, or the ability to write less information in the binary log…
Post: Percona Server 5.1.49-rel11.3
September 10, 2010 By 1 Comment
…MySQL 5.1.49. A new variable was introduced: innodb…innodb_flush_log_at_trx_commit_session. Fixed bugs Bug #576041 – Fixes long stalls while accessing the innodb…purge delay defined by innodb_max_purge_lag by removing the requirement that purge… resistent mode†The binary packages are available on…
